Search for question
Question

4. For the corrected design, please answer the following: (5 marks)

1. What normal form is this corrected design? Why?

2. Can it handle a movie being coded for multiple Genres (e.g.

Star Trek is both Sci-Fi and Action)?

3. Does it have minimal data changes if a Genre name was

changed (e.g., Thriller becomes Suspense)?

4. 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")?

5. 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.)?

6. What further corrections need to be made to this design? Why?

Fig: 1