CITA340 – Project 2 Deliverable 1
Deliverable 1:
For this deliverable, you will create your database and tables in SQL (on the SQL Server)
based on the Data Dictionary and ERD you submitted in Project 1, Deliverable 5.
You will create the following:
1. The database.
2. The tables as noted in your Data Dictionary. Submit a revised Data Dictionary if
you made changes to it since you submitted it in Project 1 Deliverable 5.
3. Primary keys within tables as applicable.
4. Foreign keys within tables as applicable.
5. Indexes within tables as applicable. (Indexes are alternative search keys to be
used in queries).
Note: The handout “Tips for Working with Databases in SQL Server 2005 Management
Studio” has instructions for creating these objects.
