Identify the key of the table and explain why you chose it


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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Identify the key of the table and explain why you chose it
Reference No:- TGS03256816

Expected delivery within 24 Hours