Question: R = Team , Opponent, Day, Player, Number, Positiong with the following set of FDs: ( 1 ) Team , Day - - Opponent, (
R Team Opponent, Day, Player, Number, Positiong with the following set of FDs: Team Day Opponent, Opponent Day Team each team plays at most one game in a dayTeam Player Number a player has one number in the team Team Day, Number Player Day Team, Opponent, Player Position each player that for a game is assigned one position in that game AnswerWhat are the candidate keys of R Is it correct to use the following step to find candidate key?
Step:Day is not appear in RHS
If Day R then Day is the only candidate key.
Day Day R
So Day is not candidate key.
Step :
The combination who can determine all the attribute is a candidate key.
Day is not in the RHS so Day is part of candidate key. We just need to list the closure of all the possible combination of the attribute which include Day and see which combination can determine all the attribute.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
