Question: For the corrected design, please answer the following: ( 5 marks ) What normal form is this corrected design? Why? Can it handle a movie

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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!