Assignment
You will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this course. You can download the latest versions of these free software products here:
Microsoft SQL Server Express
Microsoft SSMS
Before completing the Assignment, please watch the Unit 3 videos covering facets associated with physical database modeling. Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.
Based on the established database design diagram and the data contained in the Movies Dataset:
1. Identify the elements to be included in the physical data model.
2. Using SQL Server Management Studio Designer tools, create the database.
3. Using SQL Server Management Studio Designer tools, create the tables (convert entity names to table names).
4. Using SQL Server Management Studio Designer tools, associate column names (convert attribute names to column or field names), datatype, and number of characters for each attribute (field).
5. Using SQL Server Management Studio Designer tools, establish the primary keys for each of the tables.
6. Using SQL Server Management Studio Designer tools, establish any foreign keys for each of the tables (here you are converting your relationships to foreign keys).
7. Create a screenshot of your SQL Management Studio showing the database and tables you have created; embed this screenshot into your Word document.