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