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: Sarahs Shortcakes
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
- Complete your data dictionary in Microsoft Word.
- Complete your E-R diagram in Microsoft Visio then export to PDF.
- To complete this lab, upload these two files
ATTACHMENT 2 IS JUST FOR REFERENCE SO THAT U DONT MISS ON THOSE POINTS
I NEED DICTIONARY AND ER DIAGRAM FOR 2 POEPLE. BOTH NEEDS TO BE DIFFERENT