Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design an EER diagram for a database used to manage a racket sport association ( for example, US Tennis Association ) . The following is
Design an EER diagram for a database used to manage a racket sport association for example, US Tennis Association The following is a list of simplified requirements.
Each member of the sport association has an id a name, sex, age, an address, a phone number.
A member can be a player, an umpire ie referee a coach, or an officer ie a member can belong to one or more of the above categories
An umpire has a type ie national, international, etc. A coach has a certificate ie level I, II etc. An officer has an office ie a room number such as or in the main building
Each club has a name, an address, an owner, and a phone number.
Except for some officers, every member belongs to one or more clubs Hint: Make relationships between the subclasses of member and club
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started