Question: Problem 9 Model the entities and relationships (including attributes and properties of relationships) described below in an ER-diagram. Design a database (an entity-relationship diagram) to
Problem 9 Model the entities and relationships (including attributes and properties of relationships) described below in an ER-diagram. Design a database (an entity-relationship diagram) to store information about fitness gyms, and their employees. (10 points) .Each gym has a name, street number, street name, ZIP code, and one or more phone numbers. The gym names are unique. .An employee is uniquely defined by her SSN. Moreover, we store her name. .An employee may work at several gyms. For instance, Smith is working in the mornings at "X Shadyside" and in the evenings at "Fitness Factory". For every employee we record the percentage of time he or she works at each gym. Thus, employee 'Smith, above, would be recorded as working at 50% at "X Shadyside" and 50% at "Fitness Factory". Some employees may specialize in one of the following specialties: manager, receptionist, or personal trainer. Each employee has zero or one specialization. Every manager manages one or more gyms. Each gym has exactly one manager, that is, it can not be without a manager. . . . .For a personal trainer we also store the type(s) of certification he/she has. Some examples of certification are yoga, aerobics, and sports nutrition. A trainer may have zero or more certifications
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
