WGU C175 Vocab Latest 2022 Graded A+

Document Content and Description Below

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 salespe... rson 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." ✔✔ 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 back [Show More]

Last updated: 2 years ago

Preview 1 out of 11 pages

Buy Now

Instant download

We Accept: