Answered step by step
Verified Expert Solution
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!!!!!!!!
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started