Lab &: Creating Tables, Primary and Foreign Keys Overview This lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. In the FLIX2YOU product document, there is an Entity Relationship Diagram (ERD) showing the current database schema for FLIX2YOU. You will also find a script file named FLIX2YOU current.txt. The execution of the script file in SQL Server Management Studio will create seven of the fourteen tables for the FLIX2YOU database. The script will create the tables along with the primary and foreign keys for the seven table displayed on the left hand side of the ERD Part 1 The first part of this lab you will use the script provided and execute the script in your own folder in VLABS SQL Server. Provide evidence of successful execution by copy/pasting the commands and the resulting execution display into the document that you are submitting for this lab. Part 2 The second part of the lab you will create a data dictionary for the remaining seven tables (right hand side of the FLIX2YOU ERD). The data dictionary can be a formatted Word document or an Excel spreadsheet file. Please follow the format of the sample data dictionary found in Chapter 3 of the textbook. Part 3 Then you will write and execute the SQL commands in VLABS SQL Server to create the severn tables and the primary/foreign keys for those tables Copy/paste all your SQL commands into the document that you are submitting for this lab ?Provide the commands into the file IN THE ORDER that you execute the commands. Your Lab Assignment You will need to run the script in your own personal database rather than the shared one used previously. You will submit a document that includes ALL the SQL commands that you execute AND ALL the messages in SQL Server from the execution of the commands. This includes the execution of the script that has been provided to you for the first part AND the SQL commands you created for the second part of the lab For this lab, you will submit (1) the document containing all the SQL commands and the resulting messages from the execution and (2) the data dictionary file. Lab &: Creating Tables, Primary and Foreign Keys Overview This lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. In the FLIX2YOU product document, there is an Entity Relationship Diagram (ERD) showing the current database schema for FLIX2YOU. You will also find a script file named FLIX2YOU current.txt. The execution of the script file in SQL Server Management Studio will create seven of the fourteen tables for the FLIX2YOU database. The script will create the tables along with the primary and foreign keys for the seven table displayed on the left hand side of the ERD Part 1 The first part of this lab you will use the script provided and execute the script in your own folder in VLABS SQL Server. Provide evidence of successful execution by copy/pasting the commands and the resulting execution display into the document that you are submitting for this lab. Part 2 The second part of the lab you will create a data dictionary for the remaining seven tables (right hand side of the FLIX2YOU ERD). The data dictionary can be a formatted Word document or an Excel spreadsheet file. Please follow the format of the sample data dictionary found in Chapter 3 of the textbook. Part 3 Then you will write and execute the SQL commands in VLABS SQL Server to create the severn tables and the primary/foreign keys for those tables Copy/paste all your SQL commands into the document that you are submitting for this lab ?Provide the commands into the file IN THE ORDER that you execute the commands. Your Lab Assignment You will need to run the script in your own personal database rather than the shared one used previously. You will submit a document that includes ALL the SQL commands that you execute AND ALL the messages in SQL Server from the execution of the commands. This includes the execution of the script that has been provided to you for the first part AND the SQL commands you created for the second part of the lab For this lab, you will submit (1) the document containing all the SQL commands and the resulting messages from the execution and (2) the data dictionary file