InstructionsThis activity is meant to support you as you begin the database design process. An ERD is the most common visual used in the database design process; this activity allows you to draw an ER

IT 235 Module Three Activity Guidelines and Rubric Overview: This activity is meant to support you as you begin the database design process. An ERD is the most common visual used in the database design process; this activity allows you to draw an ERD based on a set of entities and attributes. Prompt: Using Visio and crow’s foot notation, design an ERD that uses the entities and attributes noted in the below table. Be sure y ou correctly notate the entity name, the attribute name, the key fields (primar y and foreign), and relationships on your ERD. Customer Order OrderDetail Product Employee CustomerID (PK) OrderID (PK) OrderID (PK) (FK) ProductID(PK) EmployeeID (PK) CustomerLastName OrderDate OrderDetail (PK) ProductDesc EmployeeLastName CustomerFirstName CustomerID (FK) ProductID (FK) ProductWeight EmployeeFirstName CustomerStreet1 EmployeeID (FK) Qty ProductPrice CustomerStreet2 CustomerZip Rubric Guidelines for Submission: Submit assignment as a Word document with double spacing, 12 -point Times New Roman font, and one -inch margins. Critical Elements Proficient (100%) Needs Improvement (80%) Not Evident (0%) Value Crow’s Foot Notation (ERD) Uses Visio to properly draw all entities in crow’s foot notation Uses Visio to draw some entities in crow’s foot notation Does not draw entities using Visio and crow’s foot notation 15 Entity and Attribute Names All entities and attributes are listed by name Some entities and attributes are listed by name No entities or attributes are listed by name 25 Primary and Foreign Keys Primary and foreign keys are notated for all entities Primary and foreign keys are notated for some entities Primary and foreign keys are not notated for any entities 25 Relationship Lines Between Entities/Keys Relationship lines for all entities are shown and properly connect related entities Some relationship lines for entities are shown and properly connect related entities No relationship lines for entities are shown, or lines do not properly connect related entities 25 Articulation of Response Submission has no major errors related to grammar, spelling, syntax, or organization Submission has major errors related to grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Submission has critical errors related to grammar, spelling, syntax, or organization that prevent understanding of ideas 10 Total 100%