Database Fundamentals and Constructing a Database using ER Diagrams and T-SQL

1. Create a database named Movie Rewind. 2. Create the tables as you described them in your ER Diagram. Note that a) For the Movie table and Actor table, the Primary Keys should “auto numbers” created with “IDENTITY( )” b) Set all Foreign Keys to NOT NULL and force changes to Primary Key values to…...