Problem
Scene(sceneID, description, sceneCategory, childrenAppropriate, actorName, characterPlayed, playID, playname)
Following functional dependencies for dramaAct:
FD1: actID-->(details, actCategory)
FD2: actCategory--> childrenAppropriate
FD3: actorName-->characterPlayed
FD4: dramaID --> dramaName
Identify the key of the table, and explain why you chose it and explain what normal form this relation is, and why.
Normalize it to 3NF. You need to show what 2NF this relations can be decomposed to (if it is not in 2NF), and then if further decomposition is needed to make all resultant relations 3NF relations.