Description
For this assignment we will use SQL's Data Definition language to create Database tables and the relational constraints that tie them together
To Do
Create the database for this Apartment Manager Database. Name it AptManagement. Use the Diagram (linked below) and write the SQL statements necessary to make the database tables. Make sure to include all the fields with the correct data types. Include all the Key and Foreign Key constraints.
Where ever a primary key is given the type "int" also make it an IDENTITY(1,1). Also remember in these diagrams bold fields are required, while the others allow nulls.
Check the code for errors and run it. We will use this database for almost all remaining Assignments. .
diagram for AptManagement database
To turn in
Turn in the SQL code You may print it, or email the code to me. If you email it include "ITC222" or "ITC 222" somewhere in the subject line. This will direct it to the correct folder in my inbox.