Design the database as a logical ERD showing attributes and multiplicities (suggest you use IE Notation in Oracle Data Modeler) called Movie. No need to include physical data types. 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, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy) What normal form is this corrected design? Why? Can it handle a movie being coded for multiple Genres? Does it have minimal data changes if a Genre name was changed (e.g., Thriller becomes Suspense)?
-
Design the
database as a logical ERD showing attributes and multiplicities (suggest you use IE Notation in Oracle Data Modeler) called Movie. No need to include physical data types. 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, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own:-
Title: Star Trek
Year: 2009 Genre: Sci-Fi
Rating: PG
Format: DVD
Director: J. J. Abrams
Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy)
-
What normal form is this corrected design? Why?
-
Can it handle a movie being coded for multiple Genres?
-
Does it have minimal data changes if a Genre name was changed (e.g., Thriller becomes Suspense)?
-
Step by step
Solved in 3 steps