Practical Exercise: Entity Relationship Diagram

I’m working on a Management exercise and need support.

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