Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

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

Students also viewed these Databases questions