$8-53.$ 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$)$

SCHEMA: SPECIALTY & CONTRACT with TEAM & PLAYER

Discuss ability and$/$or inability to use any of the Rules for Denormalization as stated on pages $344-345$ of $2019$ Hoffer, Ramesh and Topi. Draw any necessary schema with referential integrity constraints.