When a referee retires, all links to the games handled by that referee should be removed. Likewise, if a game is cancelled, all links to the referees for that game should be removed. Although it is does not happen often, a university may sometimes leave the conference of which it is a member. Naturally, we want to keep the team in the database since the university could decide to join another conference at a later date. However, if a team (university) leaves the NCAA altogether, all players and coaches of that team should be removed from the database along with the team. In all other relationships that exist in the database, the default value of Restriction of Deletion should be explicitly indicated.

a. Incorporate the above business rules in the Presentation Layer ER diagram for the NCAA database developed in the previous exercise.