Reference:
https://www.ibm.com/cloud/learn/data-modeling#toc-types-of-d-Fne2rmPT
http://www.agiledata.org/essays/dataModeling101.html
https://www.credera.com/insights/data-modeling-explained-in-10-minutes-or-less
https://medium.com/sagar-explains-azure-and-analytics-data-engineerin/introduction-to-data-modelling-c0c44432ec0b
Task 1: Consider the following attributes and write each attribute that should belong to one or more of three entities that play a role in a hotel environment: GUEST, HOTEL, and ROOM.
Address
Arrival Date
Family Name
Room Number
Floor Number
Number of Beds
Number of Parking Lots
Price
TV set available?
GUEST
HOTEL
ROOM
Task 2: What information is available in the weather forecast below?
Your assignment
List as many different types of information that you can find from the weather forecast
Group the various types of information into entities and attributes.
Entity
Attributes
Name the relationships you discover and draw a conceptual data model diagram (entities/attributes/keys/relationship) by using MySQL Workbench and paste the data model picture below.
Task 3: Analyze the example page from Ralph’s famous Raving Recipes book.
Scenario
You work as an analyst for a publishing company that wants to make recipes available on the Web. It wants the public to be able to search for recipes in a very easy way.
Your assignment
List as many different types of information that you can find from the weather forecast a.
Group the various types of information into entities and attributes.
Entity
Attributes
Name the relationships you discover and draw a conceptual data model diagram (entities/attributes/keys/relationship) by using MySQL Workbench and paste the data model picture below.
