Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!