Part 1 – Using SQL to Build the Physical Data Model
- Write SQL statements to create tables in an MS Access database that represents your physical data model developed and added below.
- Specify data types and field lengths, establish primary keys and foreign keys, and implement other constraints you identified.
- Via “Database Tools” create table relationships
I am adding, Data dictionary and physical database design to use while doing this assignment.
Part 2 – Review the SQL exercise word document attached. To complete this assignment.