Devry BIAM410 Week 2 Lab: Entity Relationship Diagram Latest 2023

Devry BIAM410
TABLE OF CONTENTS
Week 2 Lab: Entity Relationship Diagram
Scenario
In this Lab, you will create an entity relationship diagram for a restaurant review website.
The major entities involved in this database design are the following.
Restaurant – the eating establishment being reviewed
Administrator – a person authorized to enter and update information about a restaurant such as name, address, hours of operation, etc.
Reviewer – a person who write reviews of restaurants
Review – the review of a restaurant
These are the business rules that apply to these entities.
Each Restaurant can be administrated by one or many Administrators; each Administrator can administer one or many Restaurants.
Each Review is for one and only one Restaurant; each Restaurant can have zero or many Reviews.
Each Review is written by one and only one Reviewer; each Reviewer can write zero or many Reviews.
A table provided in the lab instructions gives detailed information about the attributes that must be stored for each entity.
Deliverables
After completing the steps below, submit a single Microsoft Word document file named LabWeek2xxx.docx (where xxx = your initials). This file will contain two Entity Relationship Diagrams (ERDs) copied and pasted from Microsoft Visio:
Conceptual: A conceptual data model diagram of this database showing:
the four major entities
the relationships among the entities
Logical: A logical data model diagram of this database showing:
all entities (including any needed associative entities)
the relationships among the entities
all primary and foreign keys
attributes for each entity
a data type for each attribute
Grading Rubric
Section
Deliverable
Points
2
Conceptual data model diagram includes all entities with correct entity names and all required relationships with correct cardinalities indicated via crow’s foot notation.
20
4
Logical data model diagram includes the same entities and relationships as shown on the conceptual data model and correctly resolves the many-to-many relationship using an appropriate associative entity.
30
5
Logical data model includes all required attributes for each entity with appropriate data types, correctly designates all primary and foreign keys, and uses a visually organized and readable layout.
30
Total
A quality assignment will fulfill all criteria
80
Required Software
Microsoft Visio
Access the software through the Azure Virtual Lab Environment at http://labs.azure.comLinks to an external site. or download and install a personal copy from the Student Software Store. The link to the Student Software Store is on the Course Resources Page in the Introduction and Resources Module.
The lab instructions and videos were created using Microsoft Visio 2019. Any recent version of Visio will work similarly, but some adjustments to instructions may be needed.
NOTE: Microsoft does not provide a MacOS version of Visio. Mac users should access Visio through the Citrix Virtual Lab environment.
Steps: All
Microsoft Office: Word
Access the software through the Azure Virtual Lab Environment at http://labs.azure.com or download and install a personal copy from your student Office365 account, accessed through the student portal.
Steps: All

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.