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.
Question
Solution 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...
Return to homework library