Page 1 of 1

Using ER Assistant (recommended) or Visio, create an ER diagram (ERD) that has at least 5 entities but no more than 6 en

Posted: Mon Jun 06, 2022 12:43 pm
by answerhappygod
Using ER Assistant (recommended) or Visio, create an ER diagram
(ERD) that has at least 5 entities but no more than 6 entities.
Each entity must have a minimum of 5 attributes that fully describe
that entity. The 5 attribute minimum includes the primary key only
(see note below about foreign keys in ER diagrams). All entities
must be connected with a suitable relationship that describes
cardinality (1:1, 1:M, M: M) and whether the relationship is
mandatory or optional. Every entity and relationship in your
diagram must have comments describing your business rules, i.e. the
purpose of the entity and attributes, its relationship cardinality,
and if it is mandatory or optional. You may embed these comments
into the ERD using ‘Design Notes’/‘Design Justification’ inserts or
provide them in a separate Word document. Crow’s Feet notation
style is required for all relationships. If you use ER Assistant,
this is the default notation style. If you use Visio, you must
ensure that you properly set the use of Crow’s Feet notation prior
to submitting your final ERD. Your ERD must be free of errors to
receive full points. Hint: ER Assistant provides automated checks
to ensure the ERD error free using the ‘Check Diagram’
function.