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

Calculate the price
of
your order:

«VPNEW»

Basic features

On-demand options

Paper format

Guaranteed originality

Affordable prices

Best experts

Calculate the price of your order

Expert paper writers are just a few clicks away