WGU D326 TASK 1 ADVANCED DATA
MANAGEMENT COMPLETE SOLUTION STUDY
GUIDE
◉ Modality.
Answer: It is a minimum number of entity occurrences that can be
involved in a relationship.
◉ One-to-one Binary Relationship.
Answer: 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.
◉ Ternary Relationship.
Answer: Involves three different entity types.
◉ Unique identifier.
Answer: It is used to uniquely identify each record in a database
table.
◉ Attribute.
,Answer: A property, characteristic, or fact that we know about an
entity.
◉ "A salesperson works in one office."
What is the name of this relationship?.
Answer: One-to-one binary relationship
◉ "A salesperson sells to many customers."
What is the name of this relationship?.
Answer: One-to-many binary relationship
◉ "A salesperson is authorized to sell many products, and a product
can be sold by many salespersons."
What is the name of this relationship?.
Answer: Many-to-many binary relationship
◉ What is the positioning and meaning for Cardinality and Modality
on an E-R model?.
Answer: Cardinality is the outer symbol; represents the maximum.
, Modality is the inner symbol; represents the minimum.
◉ "A salesperson works in a minimum of one and a maximum of one
office, and an office may be occupied by or assigned to a minimum of
zero and a maximum of one salesperson.".
Answer:
◉ "A salesperson may have no customers or many customers.".
Answer:
◉ Describe the ER model for "Each salesperson is authorized to sell
to at least one or many products, and each product can be sold by at
least one or many salespeople.".
Answer:
◉ "One salesperson backs-up another salesperson."
What is the name of this model?.
Answer: One-to-one unary relationship
◉ "A salesperson manages zero to many other salespersons, and a
salesperson is managed by exactly one other salesperson."
MANAGEMENT COMPLETE SOLUTION STUDY
GUIDE
◉ Modality.
Answer: It is a minimum number of entity occurrences that can be
involved in a relationship.
◉ One-to-one Binary Relationship.
Answer: 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.
◉ Ternary Relationship.
Answer: Involves three different entity types.
◉ Unique identifier.
Answer: It is used to uniquely identify each record in a database
table.
◉ Attribute.
,Answer: A property, characteristic, or fact that we know about an
entity.
◉ "A salesperson works in one office."
What is the name of this relationship?.
Answer: One-to-one binary relationship
◉ "A salesperson sells to many customers."
What is the name of this relationship?.
Answer: One-to-many binary relationship
◉ "A salesperson is authorized to sell many products, and a product
can be sold by many salespersons."
What is the name of this relationship?.
Answer: Many-to-many binary relationship
◉ What is the positioning and meaning for Cardinality and Modality
on an E-R model?.
Answer: Cardinality is the outer symbol; represents the maximum.
, Modality is the inner symbol; represents the minimum.
◉ "A salesperson works in a minimum of one and a maximum of one
office, and an office may be occupied by or assigned to a minimum of
zero and a maximum of one salesperson.".
Answer:
◉ "A salesperson may have no customers or many customers.".
Answer:
◉ Describe the ER model for "Each salesperson is authorized to sell
to at least one or many products, and each product can be sold by at
least one or many salespeople.".
Answer:
◉ "One salesperson backs-up another salesperson."
What is the name of this model?.
Answer: One-to-one unary relationship
◉ "A salesperson manages zero to many other salespersons, and a
salesperson is managed by exactly one other salesperson."
