Please answer this with explanation and show all steps.

2. (30 pts) 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 scheme of Movie is: Movie-scheme -(star _name, star address, fee, title, year, length, agent, agent address) The set of dependencies on Movie-scheme is: F- { star name -> (fee, agent, agent _address}, (star_name, title)-> fee, {title, year; -> length, agent agent address Give a decomposition of Movie-scheme into BCNF. Show your work, and justify that each of your new schemes is in BCNF. Do NOT do unnecessary decompositions - if a scheme is in BCNF, you should not decompose it any further. Is the original Movie-scheme in 3NF? Why or why not? If not, give a lossless-join decomposition of Movie-scheme into 3NF. Show your work. (1) (2) 2. (30 pts) 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 scheme of Movie is: Movie-scheme -(star _name, star address, fee, title, year, length, agent, agent address) The set of dependencies on Movie-scheme is: F- { star name -> (fee, agent, agent _address}, (star_name, title)-> fee, {title, year; -> length, agent agent address Give a decomposition of Movie-scheme into BCNF. Show your work, and justify that each of your new schemes is in BCNF. Do NOT do unnecessary decompositions - if a scheme is in BCNF, you should not decompose it any further. Is the original Movie-scheme in 3NF? Why or why not? If not, give a lossless-join decomposition of Movie-scheme into 3NF. Show your work. (1) (2)