Instructions: You are requested to design a database for a movie rental company. The following two tables contain the unnormalized data that you will use in the database. Please first draw the ER diagram to identify 4 ties and their relationships Then normalize the data and create the database in your Oracle SQL account. Finally, write six SQL statements according to the detailed instructions given in Part II. Movie Rental Database Description and its Unnormalized Data: UNNORMALIZED TABLE 1 MOVIE VALUE MOVIE QTY MOVIE CAT ID MOVIE CATEGORY MOVIE ID MOVIE TITLE 1 SciFi 10 1 Alien 1 SciFi 2 Bladerunner 1 SciFi 11 15 3 Star Wars 2 Horror 4 Texas Chainsaw Masacre 2 Horror 5 Jaws 3 Western 6 The good, the bad and the ugly 3 Western 7 Silverado 4 Comedy 8 Duck Soup 4 Comedy 9 Planes, trains and automobiles 4 Comedy 12 10 Waking Ned Devine 5 Drama. 14 11 Deep Blue Sea 5 Drama 15 12 The Fifth Element Descriptions Columns Movie ID movie id Movie Title movie title movie value The value (cost) of each movie The number of copies available for each movie movie qty movie cat id Movie Category ID movie category The category for each movie Instructions: You are requested to design a database for a movie rental company. The following two tables contain the unnormalized data that you will use in the database. Please first draw the ER diagram to identify 4 ties and their relationships Then normalize the data and create the database in your Oracle SQL account. Finally, write six SQL statements according to the detailed instructions given in Part II. Movie Rental Database Description and its Unnormalized Data: UNNORMALIZED TABLE 1 MOVIE VALUE MOVIE QTY MOVIE CAT ID MOVIE CATEGORY MOVIE ID MOVIE TITLE 1 SciFi 10 1 Alien 1 SciFi 2 Bladerunner 1 SciFi 11 15 3 Star Wars 2 Horror 4 Texas Chainsaw Masacre 2 Horror 5 Jaws 3 Western 6 The good, the bad and the ugly 3 Western 7 Silverado 4 Comedy 8 Duck Soup 4 Comedy 9 Planes, trains and automobiles 4 Comedy 12 10 Waking Ned Devine 5 Drama. 14 11 Deep Blue Sea 5 Drama 15 12 The Fifth Element Descriptions Columns Movie ID movie id Movie Title movie title movie value The value (cost) of each movie The number of copies available for each movie movie qty movie cat id Movie Category ID movie category The category for each movie