File list and database structure | Database adminstrator pages | Customer pages

The objective of this set of 4 projects is to design a database for a fictional bookshop and then develop the PHP and MySQL files to manage the database and provide online ordering for customers. Read the summary below, then click the links above to use the pages. You may add books to the catalog, and you may order books. The online ordering is strictly fictional and does not include addresses or credit card information.

Customers will be able to

• view the list of books
• link to authors' biographies
• link to book reviews
• add books to their shopping cart
• view and modify their shopping cart
• receive online and email confirmation of their order
• change their password
• reset a forgotten password.

Database administrators will be able to

• add books to the catalog
• add reviews for books in the catalog
• add biographies for authors in the catalog
• view all orders in the database
• view individual orders
• receive email notification when an order is placed.

This project starts from Mike Hillyer's discussion of database normalization on the MySQL website. It uses PHP scripting adapted from PHP and My SQL for Dynamic Web Sites, Larry Ullman, Peachpit Press, 2003, and scripting developed by the instructor, Ray Bland.

The 4 projects are:

1. Database design and development using MySQL.
2. PHP scripting for database administrator functions.
3. PHP scripting for the catalog and shopping cart.
4. PHP scripting for the order submission, order confirmation, and password changes.

© 2005 Raymond D. Bland
Created: 4/21/05
Revised: