Question: Ulizing Microso VISIO, you are to leverage the content within the prescribed narrave to develop an Enty Relaonship Diagram (ERD). Make use of the Crows

Ulizing Microso VISIO, you are to leverage the content within the prescribed narrave to develop an Enty Relaonship Diagram (ERD). Make use of the Crows Foot Database Notaon template available within VISIO. a. You will be construcng the enes [Tables] found within the schemas associated with the last digit of your student number. Student # Last Digit Schema 1 2 1 and 2 as idenfied in 6.4.1.1. 3 4 1 and 3 as idenfied in 6.4.1.1. 5 6 1 and 4 as idenfied in 6.4.1.1. 7 8 1 and 5 as idenfied in 6.4.1.1. 9 0 1 and 6 as idenfied in 6.4.1.1. b. Your ERD must include the following items: All enes must be shown with their appropriate aributes and aribute values (variable type and length where applicable) All Primary keys and Foreign Keys must be properly marked. Differenate between standard enes and intersecon enes, ulize rounded corners on tables for intersecon tables. Specify minimum and maximum cardinalies using crows foot notaon. c. Formang requirements: Avoid unnecessarily crossing relaonship lines between tables. Cardinality must be clearly visible and legible, symbols for cardinality are to be lined up to the exterior of the table. Align tables in a grid-like fashion when possible. Aempt to maintain similar buffer space between tables.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!