Mоvie Theаtre (100 pоints) A lоcаl movie theаtre wants to design a database for their movie showings. They want to keep track of the following: Movies - movieID, name of movie, movie duration, movie description. Genre of the movie such as comedy, action, sci-fi, etc. Classification of movies is also needed such as G-General, PG-Parent Guidance, MA-Mature Audiences, R-Restricted. You can add additional entities, attributes, constraints or other details as necessary. (You may have had this question on your midterm - don't overthink. Just take your thoughts to the next level.) A. In the space below, type all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table. (20 points) B. Use the normalization technique and form the 3NF tables (30 points) C. In the space below, type out the Create Table command in SQL for creating the database you have designed, make sure to use the appropriate DATATYPES, CONSTRAINTS, and CONSTRAINT REFERENCES. (30 points) Create Table ##### ( ); D. In the space below, type one SQL Insert into Values ( ); command for each table in your database. (20 points)