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: marks
What normal form is this corrected design? Why?
Can it handle a movie being coded for multiple Genres eg Star Trek is both SciFi and Action
Does it have minimal data changes if a Genre name was changed eg Thriller becomes Suspense
Can it handle a person being associated with a movie multiple ways eg Clint Eastwood both directed and played the role of Bill Munny in Unforgiven
Can it handle a person playing multiple characters eg 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
