5-37. Consider the following normalized relations for a sports league: TEAM(Team

Question

5-37. Consider the following normalized relations for a sports league:

TEAM(TeamID, TeamName, TeamLocation, TeamManager)

PLAYER(PlayerID, PlayerFirstName, PlayerLastName, PlayerDateOfBirth, PlayerSpecialtyCode)

SPECIALTY(SpecialtyCode, SpecialtyDescription) Salary)

LOCATION(LocationID, CityName, CityState, CityCountry, CityPopulation)

MANAGER(ManagerID, ManagerName)

What recommendations would you make regarding opportunities for denormalization? What additional information would you need to make fully informed denormalization decisions?

Explanation / Answer

Combine PLAYER and SPECIALITY as

PLAYER(PlayerID, PlayerFirstName, PlayerLastName, PlayerDateOfBirth,SpecialtyCode, SpecialtyDescription)

TEAM and MANAGER could be combined. As a team would have a manager.

TEAM(TeamID, TeamName, TeamLocation, MangerName)

TEAM generally belongs to a location

So

It will be as follows:

TEAM(TeamID, TeamName, LocationID, CityName, CityState, CityCountry, CityPopulation, ManagerName)

Based on the relationships me can remove the inappropriate attributes.

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.