CIS 610/710: Database Systems I
Fall 2005
Term Project Specification
Teaching Assistant: Yonghui Chen (chenyh@cis.uab.edu)
Important Dates
Demo and Program/Report Submission: November 29th, 2005 (Tuesday)
Project Description
The project is to be completed individually. Your task is to develop an Internet
bookstore (similar to Amazon.com) where the Internet users can purchase their favorite
books. The site will include html web pages and use PHP (recommended) or anything
CGI (Perl, for instance) to link to a PostgreSQL database.
(A brief comparison of PHP and CGI can be found at:
http://www.javascriptkit.com/howto/phpcgi.shtml )
The project files need to be saved in your webfiles directory.
The system must support the following basic functionalities:
1) customer account creation;
2) customer login and logout;
3) book searching;
4) shopping basket;
5) checkout and payment (including order and shipping address confirmation, etc).
In addition, you may want to provide information such as F.A.Q, service contact, etc.
1. Design Phase:
Set up a project homepage, describing the overview of your system, the web
pages you will develop and the kind of reports you plan to support.
Create an entity-relationship diagram for the model you plan to use in your
system, showing cardinality constraints.
Design the relational (or object-relational) schema, and document it using the
standard table representation (giving column headings and a sample tuple for each
relation, underlining primary keys, and using arrows to represent foreign keys),
showing security and integrity constraints.
Create an SQL definition of the data model, specifying attribute types, keys,
foreign keys, constraints, and a sample value for each attribute given as a
comment.
Write SQL queries to implement your sample queries.
