practical exercise entity relationship diagram
Hi!
Here are the instructions for this assignment.
An Entity Relationship Diagram (ERD) is a deliverable that is created during the logical data modeling process that focuses on the data, unlike a DFD that focuses on the processes. The data in an information system that are created, stored, and utilized by a user are referred to as Entities, Attributes, and Relationships and are represented in ERDs as graphical pictures.
In this activity, you will create three Entity Relationship Diagrams (ERDs) in an individual practical exercise utilizing Microsoft Visio®. You will create your ERDs in three different cardinalities, One-to-One, One-to-Many, and Many-to-Many.
Requirements
Create the ERDs in THREE different cardinalities, One-to-One (1:1), One-to-Many (1:M), and Many-to-Many (M:N), utilizing Microsoft Visio. Before you begin to work on this activity, review the Visio 2016 Crows Foot ERD Interface Demo v2 (YouTube – 7:06) (Links to an external site.) video. This tutorial will assist your understanding of how to create the ERDs. Refer to the ERD examples in the textbook.
To create the ERDs, utilize the Crows Foot Database Notation template. The template can be located by selecting the Categories (not Featured) menu selection from above the templates that are presented and selecting General/Basic Diagram. Next, choose More Shapes/Software & Database/Database/Crows Foot Database Notation, and select Create.
Your ERDs must address the following requirements:
- Submit THREE ERDs in ONE Microsoft Visio diagram.
- A One-to-One cardinality ERD.
- A One-to-Many cardinality ERD.
- A Many-to-Many cardinality ERD.
- Utilize Crows Foot Database Notation.
- Submit the following data in your ERDs:
- 2 Entities per ERD.
- 3 Attributes per each Entity.
- ONE attribute must be designated as a Primary Key Attribute.
- One of the ERDs must indicate a Null modality for the Child Entity.
- Submit your ERDs in VSDX file format.
And here is the grading rubic:
MGMT 321 6.3 Practical Exercise Rubric
| Criteria | Ratings | Pts | |||||
|---|---|---|---|---|---|---|---|
|
This criterion is linked to a Learning Outcome Deliverable Requirements The percentage of the deliverable(s) that meet the assignment’s requirements. |
|
50.0 pts |
|||||
|
This criterion is linked to a Learning Outcome Quality of Deliverable(s) The overall quality of the deliverable(s) with regard to the composition and detail. |
|
25.0 pts |
|||||
|
This criterion is linked to a Learning Outcome Accuracy of the Deliverable(s) The accuracy of the values presented in the deliverable(s). |
|
25.0 pts |
|||||
|
Total Points: 100.0 |
|||||||
#Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational #accountingassignmenthelp #accountingassignment #assignmenthelp #buyaccountingassignment #accountingassignmentwriter #domyassignment #assignmentguide #expertwriters 