A Hollywood movie studio uses a relation called Movie to keep track of information about movie stars, what fee a star charges for appearing in a movie, movies the star has appeared in, and agents. The schema of the Movie is:
Movie = (star_name, star_address, fee, title, year, length, agent, agent_address)
The set of dependencies on Movie is:
F = {star_name -> {fee, agent, agent_address}, {star_name, title} -> fee,
{title, year} -> length, agent -> agent_address}
(1) Give a decomposition of Movie into BCNF. Show your work and justify that each of your new schemes is in BCNF.
(2) Prove the original Movie schema is not in 3NF.