QuestionQuestion

You are working for country club with thousands of members. You have been tasked with designing a database to keep track of the members and their guests.

The club keeps track of mail and telephone contact information, name and membership number. When a member joins the club they can become a social member with pool, racket ball and weight room privileges or golf member which includes all of the social member privileges plus access to the golf course.

Develop, document and design an EER for this situation.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

When the EER diagram was built as above, there were considered the following entities, facts and relationships (detached from the provided text):
- A member can be either an individual person or a company as well; this is why it was created the UNION type Members; it represent the union subset of superclasses Person and Company;
- Since each member must belong to a company or a person, it was used a total constraint(it is commonly used when each entity from the superclass needs to be a member of some subclass and this case it is marked with double-edge);
Both Golf and Social subclasses are designed exclusively based on the distinct...
$40.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats