WGU Course C170 - Data Management (Applications)
A salesperson is authorized to sell many products and a product can be sold by many salespersons.
Which kind of binary relationship does this scenario describe?
...
WGU Course C170 - Data Management (Applications)
A salesperson is authorized to sell many products and a product can be sold by many salespersons.
Which kind of binary relationship does this scenario describe?
A One-to-one
B One-to-many
C One-to-one binary
D Many-to-many Correct answer- D
Which kind of relationship is displayed in this entity-relationship diagram?
A Many-to-many unary
B Many-to-many binary
C One-to-one unary
D One-to-one binary Correct answer- A
Which kind of relationship is displayed in this entity-relationship diagram?
A Binary many-to-many
B Unary one-to-one
C Ternary many-to-many
D Ternary one-to-one
D Unary many-to-many
E Binary one-to-one Correct answer- B
How is this portion of the entity-relationship diagram read, from left to right?
A At least one book was written by an author.
B Only one book was written by one author.
C No books are written by an author.
D One book was written by more than one author. Correct answer- A
Which two examples are attributes?
Choose 2 answers
1 A meeting code
2 A person attending a meeting
3 An employee number
4 A sales meeting
A 1,3
B 2,4 Correct answer- A
Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table?
A Restrict
B Cascade
C Matching
D Set-to-Null Correct answer- D
In this entity-relationship diagram, Salesperson 361 is related to two customers. The table follows the restrict delete rule.
What happens if someone tries to delete Salesperson 361 from the customer records?
A The delete occurs immediately.
B The lack of a salesperson is flagged for later.
C A new salesperson is assigned instead.
D The delete is prohibited. Correct answer- D
[Show More]