PROJECT GUIDELINE:

Phase II consists of the relational schema, create table statements, sets of SQL statements for tasks in IFD.

1. COVER PAGE:
You should fill the group member information  into this cover page (http://www-static.cc.gatech.edu/classes/AY2008/cs4400_fall/coverpage.pdf) and attach it to the project. We assume that the group members are not changed from phase I. You need to email the professor and your TA if there is a change in your group. No change is allowed during phase III.

2. ER-DIAGRAM:
The solution for ER-Diagram from the class website can be used for phase II. You need to indicate in the project which ER-Diagram is used for phase II. If  your own solution is used, the revised ER-Diagram from phase I has to be included.

3. CREATE TABLE STATEMENTS:
This part contains the create table SQL statements for all the tables in the relational schema. All the integrity constraints, where applicable (primary key, foreign key and null constraint), must be included.

4. SQL STATEMENTS:
This part consists of the sets of SQL statements to perform all tasks in the IFD and Task Decomposition posted on the class website. The tasks should be numbered according to the task numbers in the IFD solution.

The format of this part is as follows:

TASK 1: User Login
<Set of SQL Statements>

The format and content of the output from the set of SQL statements for each task, where applicable, should be ready to display in the GUIs, i.e. statistics, sorted records. You should avoid to use the loop to iteratively retrieve information from the database if some SQL statements can be used to perform the same task.