WGU C175 Vocab Latest 2022 Graded A+

WGU C175 Vocab Latest 2022 Graded A+
E-R Model ✔✔It is well named, as it diagrams entities (together with their attributes) and the
relationship among them.


Describe the ER model for "A salesperson works in one office."
- What is the name of this relationship?


exists when two entities are associated/relationship
- Ex. A professor teaches many classes. ✔✔- One-to-one binary relationship




Describe the ER model for "A salesperson sells to many customers."
- What is the name of this relationship?




It means that a single occurrence of one entity type can be associated with a single occurrence of
the other entity type and vice versa. ✔✔- One-to-many binary relationship

, Describe the ER model for "(L to R) A salesperson is authorized to sell many products; (R to L) a
product can be sold by many salespersons."
- What is the name of this relationship? ✔✔- Many-to-many binary relationship




What is the positioning and meaning for Cardinality and Modality on an ER model? ✔✔-
Cardinality is the outer symbol; represents the maximum.
- Modality is the inner symbol; represents the minimum.


Describe the ER model for "(L to R) A salesperson works in a minimum of one and a maximum
of one office, or exactly one office." "(R to L) An office may be occupied by or assigned to a
minimum of no salespersons or a maximum of one salesperson." ✔✔




Describe the ER model for "A salesperson may have no customers or many customers." ✔✔