Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLS HELP!!!!!!!! Draw an ERD Diagram for the following situation. Include the cardinality of relationships and make sure to define the primary key(s) (PK), foreign

PLS HELP!!!!!!!!

image text in transcribed

Draw an ERD Diagram for the following situation. Include the cardinality of relationships and make sure to define the primary key(s) (PK), foreign key(s) (FK), and which attributes are involved in each relationship. Many to Many relationships may not be used, and your final product should be in 3" normal form. SITUATION Globo-Gym International (Globo-Gym) is a large, nation-wide gym operating in Canada. Globo-Gym has an advanced customer tracking program which records their user data in a database and enables users to view their activity at all locations. When signing up for a membership, Customers must provide their first name, last name, address, and date of birth. The address must contain the country, province, city, street, and postal code. Family members living in the same house tend to register together. For younger customers, Globo-Gym keeps tracks of one parent that is also a customer if possible. All customers must be assigned a unique medical ID and must provide an emergency contact name and phone number alongside the medical ID. Once all the customer's information is entered, they must also be assigned a fitness plan for Globo-gym. These plans differ gym to gym. A fitness plan has a name, cost, start date, and end date - customers must enroll in only one fitness plan at one time but Globo-Gym keeps track of all fitness plans that a customer has enrolled in. Fitness plans can be customized but are not unique to one customer. In order to pay for each fitness plan that they may partake in throughout their membership, customers must also submit their payment information. Payment information includes credit card type, number, security code, and expiry date; this information is also unique to each customer. Customers must pay separately for each fitness plan at the start date of that fitness plan with one form of payment. Globo.gym also keeps a record of every single fitness plan transaction using a customer's payment information. Every gym's country, province, city, street, and postal code are also stored in the database. Activity elements include a name, date, number of repetitions, and whether or not the activity was done with weights. Every plan consists of many activities and an activity may be included on many plans. This is similar to the way fitness plans must be available in at least one gym and each gym must have at least one fitness plan available. However, it is not always the case that a customer will have recorded activity on a plan as they must use their membership after buying it for activity data to be recorded

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

Recommended Textbook for

JDBC Database Programming With J2ee

Authors: Art Taylor

1st Edition

0130453234, 978-0130453235

More Books

Students also viewed these Databases questions

Question

Organize and support your main points

Answered: 1 week ago

Question

Move smoothly from point to point

Answered: 1 week ago

Question

Outlining Your Speech?

Answered: 1 week ago