This exercise contains additional information to the information given in Exercises 17 and 18 in Chapter 3 in order to give you an opportunity to work with various types of enhanced ER modeling constructs.

Both coaches and referees are basketball professionals who have chosen different careers within this profession. Players no longer serve as counselors in summer youth basketball camps.

Instead, some of the players and all of the coaches do voluntary service as trainers in the summer youth basketball camps. Incorporate this additional information into the Presentation Layer ER diagram that you developed for Exercise 17 in Chapter 3.

(Original Presentation Layer ER diagram below)

Number_of_teams UniversityName Annual_budget Current_ranking Conference name LocationID HomeCourt_Capa city (University Name Address Conference belongs to (0.1) NCAA ID Total_players University Location Name Team_Name2 (1.M) Team (22) Title works for Coaches Game Year Telephone_numbe played between Team_Name1 Gameld Salary (1.M) (1.1) Address (0,M) SSN Games GameDate (13.20) plays (OM) Attendance Name Player (10 M Final_Score Major Grade_point_avg has > Certifications points_scored assists Telephone_numbe (3,3) no_of_fouls minutes_played Referee Total_Exp_Years rebounds NCAA_ID Address Name Salary Number_of_teams UniversityName Annual_budget Current_ranking Conference name LocationID HomeCourt_Capa city (University Name Address Conference belongs to (0.1) NCAA ID Total_players University Location Name Team_Name2 (1.M) Team (22) Title works for Coaches Game Year Telephone_numbe played between Team_Name1 Gameld Salary (1.M) (1.1) Address (0,M) SSN Games GameDate (13.20) plays (OM) Attendance Name Player (10 M Final_Score Major Grade_point_avg has > Certifications points_scored assists Telephone_numbe (3,3) no_of_fouls minutes_played Referee Total_Exp_Years rebounds NCAA_ID Address Name Salary