PART 1
Assignment Instructions
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:
· Identify the elements to be included in the physical data model.
· Using SQL Server Management Studio Designer tools, create the database.
· Using SQL Server Management Studio Designer tools, create the tables (convert entity names to table names).
· 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).
· Using SQL Server Management Studio Designer tools, establish the primary keys for each of the tables.
· 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).
· Create a screenshot of your SQL Management Studio showing the database and tables you have created; embed this screenshot into your Word document.
Please use the following guidance document to help you complete this assignment: Instructions for Using the Microsoft SSMS Designer Tools to Generate the Movies Database
You will need to use the established database design diagram and Movies Dataset for this assignment. Download and use the diagram and data for your analysis.
Assignment Requirements
Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots from SQL Server Management Studio showing the work performed for the creation of the database and tables.
PART 2
In Assignment part 1, you created a physical model for a database using SQL Server Management Studio Designer tools. You can also create a database using SQL Data Definition Language (DDL) statements. In this unit, you will create the same database using the SQL CREATE statement to create the database and the tables. In business, you will have choices of different methods for creating a database, so you want to be familiar with the various options.
Assignment Instructions
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:
Use the SQL Management Studio Query Window to implement a new version of the Movies database. You will name this database Movies_2.
· Create the database using the SQL CREATE statement.
· Create the tables using the SQL CREATE statement.
· Associate column names and datatype using the SQL create statement.
· Establish the primary and foreign keys for each table.
· Create a screenshot of your SQL Queries that you used to create the database and tables.
You will need to use the established database design diagram and Movies Dataset you used in Assignment 1 of this unit for the Movies 2 implementation. Download and use the diagram and data for your analysis.
Assignment Requirements
Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.
Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots of your SQL statements and confirmatory output (e.g., table structure definitions) into the Word document.