QUESTIONS:

Use: Title $->$ T$,$ Year $->$ Y$,$ Length $->$ L $,$ Genre $->$ G$,$ Studio $->$ S$,$ City$\_$Studio $->$ C$,$ Actor $->$ A$,$

Rating $->$ R

$1)$ Explain $($not just list$)$ all the anomalies that you can find in the Movie relation. $(10$p$)$

$2)$ A$-$ List all the Functional Dependencies in the Movie relation. $(10$p$)$

B$-$ Find the candidate Key and explain why it is the candidate key $(5$p$)$

$3)$ a$-$ Is Movie in $1$NF$?$ Is Movie in $2$NF$?$ Is it in $3$NF$?$ Is it in BCNF$?$ Explain why in each

case. $(5$p$)$

b$-$ If it is not in BCNF$,$ design it in a way that is in BCNF$.$ Go step by step and explain

all the steps, the reasons to take them and the functional dependencies involved in

the decisions. $(20$p$)$