Step 1. Create the Movie Theater database using SQL Server. Use the following specifications: Module3MovieTheaterSpecs.pdfPreview the document You will find more information on SQL Server under FAQs. Apply the concepts of database systems that you have learned this week. Use the following data to create the databases using SQL Server:

Movies Movie_ID Movie_Name 13762 Forrest Gump 17698 The Shawshank Redemption 19868 A Few Good Men 12987 The Godfather Theaters Theater_ID Theater_Name 103 Cine 20 West 105 Screen 12 North 107 Filmology 8 MovieTimes Movie_ID Theater_ID Movie_Time 13762 103 7:00 PM 2/5/2013 17698 105 7:05 PM 3/6/2014 19868 103 9:00 PM 1/15/2015 12987 107 7:00 PM 2/14/2016

Using the Table Designer, create the tables and keys.

Using the editor, add the given test data and test data of your own to the tables. Create a new database diagram. Add relationships to your database diagram.

Step 2. Submit a paper (2-5 pages) including, at a minimum, the following components with screenshots and headings in this order: Describe the potential use of the database. Describe the potential actors and users of the database. Describe the data contained in the database plus include screenshots of the data from SQL Server. Describe the tables, fields, and keys in the database plus include screenshots of your table designs from SQL Server. Describe the relationships in the database plus include screenshots of a diagram from SQL Server. Describe your recommendations for improvements and future enhancements to the database.