Assume that you have the following table: (TeamID, PlayerNumber, PlayerName, Tea

Question

Assume that you have the following table: (TeamID, PlayerNumber, PlayerName, TeamName, TeamManager, ManagerNationality, DOB, Position, Region, (GameDate, Shots, Goals, GameTime, GameStadium, StadiumCapacity, StadiumAddress)) Assume that the following functional dependencies beyond that the primary key are valid: TeamID TeamName, TeamManager, ManagerNationality, Region TeamID, GameDate GameTime, GameStadium, StadiumCapacity, StadiumAddress GameStadium StadiumCapacity, StadiumAddress TeamManager ManagerNationality Convert the table into 3NF. Put your answer on the test paper.

Explanation / Answer

Below are the entities in 3NF form:-

Team

Game

Stadium

TeamManager

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---