1. Write MySQL statements to create a database named MovieCo for the following (partial) ERD and Relational Database Schema. You will need to write MySQL statements to create the database and two tables in that database. Figure 1: MovieCo ERD Table Name PRICE PKPRICE CODE Relational Database Schema: Field PRICE CODE PRICE DESCRIPTION PRICE RENTFEE MOVIE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE PRICE DAILYLATEFEE MOVIE NUM MOVIE TITLE MOVIE YEAR MOIVE COST MOVIE GENRE PRICE_CODE Hox MOVIE PK MOVE NUM MOVIE TITLE MOVIE YEAR MOVIE COST GENRE MOVIE FKY PRICE CODE Type CHAR(2) VARCHAR(20) DECIMAL (5,2) DECIMAL (5.2) CHAR(3) VARCHARGE) CHAR(4) DECIMAL (5,2) VARCHAR(50) CHAR(2) Description PRIMARY KEY NOT NULL PRIMARY KEY NOT NULL FOREIGN KEY (PRICE_CODE) REFERENCES PRICE(PRICE_CODE) 2. Now write MySQL statements to insert data into the two tables you just | created. PRICE Price_Code Price_Description Price_Rentfee Price Dailylatefee 01 Standard 02 New Release MOVIE Movie Num Movie Name 00001234 The Cesar Family Christmas 00001235 Smokey Mountain Wildlife 2 3.5 1 3 Movie_Year Movie_Cost Movie_Genre Price_Code 39.95 FAMILY 59.95 ACTION 2014 2011 02 01