Create your conceptual diagram to show the four entities

Assignment Help Computer Engineering

Reference no: EM133626525

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 concierge services. 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) represents the current data they are storing outside of a database. As you can see, it's a very archaic and disorganized system for maintaining their data and it is becoming unwieldy. They need your help to organize their data so that they can manage it more effectively to grow their business.

1. Your initial task is to review the data provided and determine the entities and relationships that would exist for your relational database design. You'll document them in upcoming steps.

Refer to IT163_Example1 to 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?
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 of each entity and the relationships between them. There will be 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 Database Notation template.

3. Create your conceptual diagram to show the four entities you identified.

Reference no: EM133626525

Questions Cloud

Why do we use imports : Why do we use imports? Imports allow us to plagiarize other people's work. Imports make your code more uniform. Imports write the code for us. Imports allow us

Design a star schema for modelling the data warehouse : Design a Star Schema for modelling the data warehouse for Millennium College. Ensure every dimension have an appropriate Primary Key.

Explain your understanding of each of negotiation elements : Explain your understanding of each of the negotiation elements. Provide comparative analysis of each stakeholder's decision, incorporating negotiation elements.

Development of the healthy marriage initiative : Do you think that legislators' personal beliefs and values were influential in the development of the Healthy Marriage Initiative

Create your conceptual diagram to show the four entities : Using Microsoft Visio, create a new ERD diagram. Choose the Crow's Foot Database Notation template - Create your conceptual diagram to show the four entities

Advanced respiratory disease whose has inadequate nutrition : The nurse is caring for an older adult homebound client with advanced respiratory disease whose has inadequate nutrition.

What do you use to document your work : teammates run your code, and display your visualizations. What do you use to document your work? 1 point A spreadsheet A data frame An R Markdown notebook

Nutrition and oral hydration : Describe the procedure? What are the indications? What are the outcomes/Evaluation?

Combine data from multiple csv files into a single table : combine data from multiple CSV files into a single table, calculate individual and abnormal stock returns, and compute returns for a portfolio of stocks

User Account

All Pages