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$ entities 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$\_$ID MOVIE$\_$TITLE

$1$ Alien

$2$ Bladerunner

$3$ Star Wars

$4$ Texas Chainsaw Masacre

$5$ Jaws

$6$ The good, the bad and the ugly

$7$ Silverado

$8$ Duck Soup

$9$ Planes, trains and automobiles

$10$ Waking Ned Devine

$11$ Deep Blue Sea

$12$ The Fifth Element

Columns

$q,$

movie$\_$id

movie$\_$title

movie$\_$value

movie$\_$qty

movie$\_$cat$\_$id

movie$\_$category

MOVIE$\_$VALUE

$10$

$8$

$15$

$7$

$7$

$7$

$7$

$5$

$5$

$12$

$14$

$15$

Descriptions

Movie ID

Movie Title

The value $($cost$)$ of each movie

The number of copies available for each movie

Movie Category ID

The category for each movie

MOVIE$\_$QTY

MOVIE$\_$CAT$\_$ID

MOVIE$\_$CATEGORY

$1$ SciFi

$1$ SciFi

$1$ SciFi

$2$ Horror

$2$ Horror

$3$ Western

$3$ Western

$4$ Comedy

$4$ Comedy

$4.$ Comedy

$5$ Drama

$5$ Drama