Description
Project Checkpoint 2 is due on Week 11 during the lab. You are required to provide the following:
-
A database implementing the relational schema you designed for Project Checkpoint 1. The database should contain all the identi ed relations (tables) and some sample data for each of the tables. You can either insert the data manually or load it using a similar procedure to the one covered in the labs.
-
A script containing all the SQL queries and data modi cation statements (INSERT/UPDATE/DELETE) speci ed in your use-case diagram. There should be at least 20 SQL statements and they should dis-play diversity, i.e., there should be queries of di erent format and modi cation statements of di erent type.
There are two les each group is required to provide:
database le containing all the relations and the data script with all the SQL statements
You are also required to show that your SQL queries work on the database. For this, you can either run the queries on your machine or you can email the TA the database and the script prior to the meeting.
