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

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 Excellent

The deliverable(s) met ALL of the assignment's requirements.

45.0 pts Very Good

The deliverable(s) met MOST of the assignment's requirements.

40.0 pts Satisfactory

The deliverable(s) met MANY of the assignment's requirements.

35.0 pts Near Failing

The deliverable(s) met SOME of the assignment's requirements.

0.0 pts Failing

The deliverable(s) did NOT meet ANY of 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 Excellent

The composition and detail of the deliverable(s) was at a VERY HIGH level.

21.0 pts Very Good

The composition and detail of the deliverable(s) was at a HIGH level.

17.0 pts Satisfactory

The composition and detail of the deliverable(s) was at a MODERATE level.

13.0 pts Near Failing

The composition and detail of the deliverable(s) was at a LOW level.

0.0 pts Failing

The composition and detail of the deliverable(s) was at an UNSATISFACTORY level.

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 Excellent

ALL of the data in the deliverable(s) was accurate.

21.0 pts Very Good

MOST of the data in the deliverable(s) was accurate.

17.0 pts Satisfactory

MUCH of the data in the deliverable(s) was accurate.

13.0 pts Near Failing

SOME of the data in the deliverable(s) was accurate.

0.0 pts Failing

NONE of the data in the deliverable(s) was accurate.

25.0 pts

Total Points: 100.0