Question: Consider the relation schema lineup = fTeam, Opponent, Day, Player, Number, Positiong, with the following set of FDs: ( 1 ) fTeam, Dayg ! Opponent,
Consider the relation schema lineup fTeam, Opponent, Day, Player, Number, Positiong, with the following set of FDs: fTeam, Dayg Opponent, and fOpponent, Dayg Teameach team plays at most one game in a day fTeam, Playerg Numbera player has one number in the team they're on fTeam, Day, Numberg Playertwo players on the same team cannot have the same number at the same time fDay, Team, Opponent, Playerg Positioneach player that is part of the lineup for a game is assigned one position in that game What are the candidate keys of lineup? Justify your answer ie include the main steps used for nding thecandidate keys Mark Find a minimal cover of Justify your answer ie include the main steps used for nding a minimal cover Mark Demonstrate whether lineup, given satises NF and if not, identify a NF decomposition for lineup. Youneed to include the main steps used for identifying the NF decomposition. Mark
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
