For each of the following entities give a superkey a candida

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, year

Solution

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