For each of the following entities, give a superkey, a candidate key, and a prim
ID: 3923926 • Letter: F
Question
For each of the following entities, give a superkey, a candidate key, and a primary key. Clearly indicate which one is superkey, which one is candidate key, and which one is primary key. List any assumptions you make about the given situation (Please make only reasonable assumptions. You cannot add attributes to any entity), 'Movie' table: movieTitle, movieYearOfProduction, mainActors, director, duration, studioOfProduction 'NFL standing' table: teamName, numberOfWins, numberOfLosses, ranking, bestPlayer, yearExplanation / Answer
a ) primary key - movieTitle
Candidate primary key - mainActors+movie YearofProduction + director
Super key - movie Title + director
b)
Primary key - teamName
Super key - teamName + year
Candidate key- bestPlayer + year + ranking