Purpose All databases start with data. Without the data there would be no need for a database. In this scenario, Fit @ Home provides home gym conc Their services include equipment subscription packages and personal training video sessions in the convenience and safety of home. The data provided to you (IT163_Data1 E) represents the current data they are storing outside of a database. As you can see, it's a very arch disorganized system for maintaining their data and it is becoming unwieldy. They need your help to organize their data so that they can manag effectively to grow their business Assignment Instructions For this assignment, you will be using the diagraming application Microsoft Visio, obtained through Microsoft Azure. See the Azure Course Resources for details. 1. Your initial task is to review the data provided and determine the entities and relationships that would exist for your relational database design. document them in upcoming steps. Refer to IT163_Example1 Eto see a demonstration of how to work through this process Things to consider as you analyze the data What groupings of information exist? What data depends on other data? How do these groupings relate to one another? o Look for one-to-one one-to-many and many-to-many relationships in the data An entity relationship diagram at a conceptual level will only show the names for each entity and the relationships between them. There wi no actual data depicted in the model you are building, Reference: Relational Database Design and implementation (4th ed.) Chapter 4 Entities and Relationships 2 Using Microsoft Visio create a new ERD diagram Choose the Crow's Foot Purpose All databases start with data. Without the data there would be no need for a database. In this scenario, Fit @ Home provides home gym conc Their services include equipment subscription packages and personal training video sessions in the convenience and safety of home. The data provided to you (IT163_Data1 E) represents the current data they are storing outside of a database. As you can see, it's a very arch disorganized system for maintaining their data and it is becoming unwieldy. They need your help to organize their data so that they can manag effectively to grow their business Assignment Instructions For this assignment, you will be using the diagraming application Microsoft Visio, obtained through Microsoft Azure. See the Azure Course Resources for details. 1. Your initial task is to review the data provided and determine the entities and relationships that would exist for your relational database design. document them in upcoming steps. Refer to IT163_Example1 Eto see a demonstration of how to work through this process Things to consider as you analyze the data What groupings of information exist? What data depends on other data? How do these groupings relate to one another? o Look for one-to-one one-to-many and many-to-many relationships in the data An entity relationship diagram at a conceptual level will only show the names for each entity and the relationships between them. There wi no actual data depicted in the model you are building, Reference: Relational Database Design and implementation (4th ed.) Chapter 4 Entities and Relationships 2 Using Microsoft Visio create a new ERD diagram Choose the Crow's Foot