Business data analysis, entity identification and E-R diagrams

Learning Objectives

• Model Business Data
• Complete E-R Diagram

Microsoft Visio

• Required Software: Microsoft Visio  (Links to an external site.)
• Visio Resources: A beginner’s guide to Visio (Links to an external site.),  (Links to an external site.)Microsoft Visio Tutorials (Links to an external site.)

Instructions

Lab homework: 

Before attempting this lab, review the previous zoom session.

In this lab, analyze the above case study to determine the entities required for your database, the attributes of each entity, and the relationships required between the entities.  Then construct a data dictionary describing each entity and the relationships between entities.  After the data dictionary is complete, use it to create an E-R diagram in Microsoft Visio. 

Mimic the previous zoom session to analyze Sarah's Shortcakes and create a data dictionary and E-R diagram. 

You will not be able to complete the next lab without finishing this one. 

Deliverables

1. Complete your data dictionary in Microsoft Word.
2. Complete your E-R diagram in Microsoft Visio then export to PDF.
3. To complete this lab, upload these two files