How to Build Programming Exercise I

There are many ways to construct a database-driven website such as ASP.NET. The following slides explain how to construct a database-driven website by using the LAMP technologies including

• Linux: an operating system,
• Apache: a web server,
• MySQL: a relational database, and
• PHP/Python/Perl: a general-purpose language.

The construction may include the following steps:

1. Examining the exercise specifications very carefully,
2. Database design (E-R modeling or normalization),
3. Database implementation (SQL),
4. Web user interface construction [(X)HTML],
5. Calling a PHP script with embedded SQL commands, and
6. Testing the exercise thoroughly.