Create a relational database consisting of at least three related tables, using a variety of datatypes. Query the database and modify the data it contains in various ways (specifications to be discussed in detail as the semester progresses).
 

 Due dates:

•  Preliminary database project proposal                                                  Sept. 23

•  Detailed database project design                                                          Sept. 30

•  Table structure with representative data                                                Oct. 28

•  Database project completed:

• Optional in-class presentation                                                      Dec. 9

• Hand or mail in SQL statements (*)                                             Dec. 9

(*) Material to hand or mail in:
 

• 1-2 page (revised) description of the database project (structure, how it might be used)
• SQL statements used to create the tables and other database objects
• Results of running the various queries and procedures (output files)