Entity Relationship Data Model

Reference:

• https://www.ibm.com/cloud/learn/datamodeling#toctypesofdFne2rmPT
• http://www.agiledata.org/essays/dataModeling101.html
• https://www.credera.com/insights/datamodelingexplainedin10minutesorless
• https://medium.com/sagarexplainsazureandanalyticsdataengineerin/introductiontodatamodellingc0c44432ec0b

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.

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.

• 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 Ralphs 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

1. List as many different types of information that you can find from the weather forecast a.

2. Group the various types of information into entities and attributes.

3. 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.