Consider the following normalized relations for a sports league: TEAM(TeamID, Te
ID: 3668025 • Letter: C
Question
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
I will denormalized :
PLAYER and SPECIALTY
TEAM and MANAGER
- because, these are the frequently retrieve information from table. So, it will reduce JOIN time of two table.
Most Important information Need to do Denormalization:
what are the information going to fetch from database frequentluy.