WGU D547 APN1 TASK 1 DATA ANALYSIS
COMPLETE PAPER WITH SOLUTIONS
◉ 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."
What is the name of this model?.
Answer: One-to-many unary relationship
◉ "A product can either be part of no other products or be part of
several other products, and a product can either be composed of no
other products or be composed of several other products."
COMPLETE PAPER WITH SOLUTIONS
◉ 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."
What is the name of this model?.
Answer: One-to-many unary relationship
◉ "A product can either be part of no other products or be part of
several other products, and a product can either be composed of no
other products or be composed of several other products."
