Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID$,$ Title, Year Released, Genre $($e$.$g$.,$ sci$-$fi$,$ comedy, thriller, etc.$),$ Rating $($e$.$g$.,$ G$,$ PG$,$ R$,$ etc.$),$ Format $($e$.$g$.,$ VHS$,$ DVD$,$ MP$3,$ etc.$),$ a free$-$form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: $(2$ marks$)$ID: $1$Title: Star TrekYear: $2009$Genre: Sci$-$FiRating: PGFormat: DVDDirector: J$.$J$.$ AbramsStarring: Chris Pine $($Capt$.$ Kirk$),$ Zachary Quinto $($Mr$.$ Spock$)$ Zoe Saldana $($Uhura$),$ Karl Urban $($Bones McCoy$)$What normal form is this design? Why? What should be done to correct the design? $(3$ marks$)$Draw your corrected design as a logical ERD showing attributes and multiplicities. This must be done as a drawing $($suggest you use IE Notation in Oracle Data Modeler, although you may use another drawing tool such as Microsoft Visio if you wish$).$ No need to include physical data types. Modify the sample data from step $1$ in a new page of the spreadsheet to match this design. $(5$ marks$)$For the corrected design, please answer the following: $(5$ marks$)$What normal form is this corrected design? Why?Can it handle a movie being coded for multiple Genres $($e$.$g$.$ Star Trek is both Sci$-$Fi and Action$)?$Does it have minimal data changes if a Genre name was changed $($e$.$g$.,$ Thriller becomes Suspense$)?$Can it handle a person being associated with a movie multiple ways $($e$.$g$.,$ Clint Eastwood both directed and played the role of Bill Munny in Unforgiven$)?$Can it handle a person playing multiple characters $($e$.$g$.,$ Eddie Murphy in The Nutty Professor played seven different roles: Sherman Klump, Buddy Love, Lance Perkins, etc.$)?$What further corrections need to be made to this design? Why?Finalize your design as a logical ERD showing attributes and multiplicities. This must be done as a drawing $($suggest you use IE Notation in Oracle Data Modeler, although you may use another drawing tool such as Microsoft Visio if you wish$).$ There is no need to include physical data types. Modify your sample data from step $3$ to a new page of the spreadsheet, and include the following: $(5$ marks$)$The additional movies referenced in step $4.$Add two additional records of your own. $($Hint: The Matrix would be one good choice with the Wachowski siblings having multiple crew roles.$)$