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 relationshipDescribe 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 customer