Answered step by step
Verified Expert Solution
Link Copied!

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 (i.e., referee), a coach, or an officer (i.e. a member can belong to one or more of the above categories).
An umpire has a type (i.e., national, international, etc.). A coach has a certificate (i.e., level I, II, etc.). An officer has an office (i.e., a room number such as 101 or 212 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Joe Celkos Data And Databases Concepts In Practice

Authors: Joe Celko

1st Edition

1558604324, 978-1558604322

More Books

Students also viewed these Databases questions

Question

What is job rotation ?

Answered: 1 week ago