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