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 customers." Describe the ER model for "(L to R) Each salesperson is authorized to sell to at least one or many of our products."and "(R to L) Each product can be sold by at least one or many of our salespersons." Describe the ER model for "One salesperson backs-up another salesperson." - What is the name of this model? - One-to-one unary relationship Describe the ER model for "(L to R) A salesperson manages zero to many other salespersons." and "(R to L) A salesperson is managed by exactly one other salesperson." - What is the name of this model? - One-to-many unary relations