You will draw an ERD (Entity Relationship Diagram for the following case. You must state all assumptions and questions necessary. Moreover, you should make some effort to define attributes (i.e. fields as well as primary and foreign keys) for the entities.

Background

James Sportsdome is an athletic facility offering services in Winona, Minnesota. It consists of a recreation facility where residents have the opportunity to participate in multiple athletics classes/programs.

Case

Members: When joining the Sportsdome, individuals are assigned a unique four-digit Member ID number. This information along with their name, address, phone number, gender, birth date, and date of membership are recorded. At the time of enrollment, each member decides on one of three available membership types along with a fixed membership fee: Platinum ($400), Gold ($300), and Silver ($200). This is a one-time fee that establishes a fixed annual membership. Each membership type allows access to at least one facility.

Facilities and Equipment: The Sportsdome has a variety of facilities and equipment choices. Each facility has a unique room number and a size limitation associated with it. Some of the rooms contain pieces of exercise equipment; all have a serial number (provided by its manufacturer) that is used for inventory purposes. In addition, for each piece of equipment, purchase date and the date of its last maintenance are recorded. Each piece of equipment belongs to a specific equipment type, such as stair master machine, and is assigned a unique three-digit identification number. The description, the manufacturers model number, and the recommended maintenance interval for that model of equipment are also kept on file.

Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.