Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Chen s notation or Crow s foot, draw an entity relationship diagram for the scenario below. using any ER Modelling tool such as Draw.io

Using Chens notation or Crows foot, draw an entity relationship diagram for the scenario below. using any ER Modelling tool such as Draw.io/Vision/MySQLWorkbench
(5 marks)
Munkles Strength Hub (MSH) is a gym franchise in Australia. Munkles Strength Hub has a gym in every single state, including two gyms in Victoria and a head office in Melbourne, Victoria. MSH require a database management system to help track their customer, gym location, head office, and employee details. Theyd like to track customer details which include customer name, gender, address, gym membership type, and when they signed up. Theyd like to track each gym locations details which include state, city, size of premises, number of machines, and number of members. Theyd like to track the head offices location, lease renewal date, and number of available desks to work at. And finally, theyd like to track employee details which include employee name, title, gender, address, employment start date, and location they work at.

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_2

Step: 3

blur-text-image_3

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

Databases Illuminated

Authors: Catherine M. Ricardo, Susan D. Urban, Karen C. Davis

4th Edition

1284231585, 978-1284231588

More Books

Students also viewed these Databases questions

Question

5. Explain the supervisors role in safety.

Answered: 1 week ago

Question

7. Explain how an employee could reduce stress at work.

Answered: 1 week ago