DATA C170 Practice Test 1 with Answer Key

C170 (Data Management Applications): Practice Test 1

1. A customer can purchase many products and a product can be purchased by many customers.

Which kind of binary relationship does this scenario describe?

a. Many-to-many
b. One-to-many
c. One-to-one binary
d. One-to-one



2.




Which kind of relationship is displayed in this entity-relationship diagram?

a. Binary one-to-one
b. Unary many-to-many
c. Ternary one-to-one
d. Binary many-to-many
e. Unary one-to-one

, f. Ternary many-to-many



3.




Which kind of relationship is displayed in this entity-relationship diagram?

a. One-to-one binary
b. One-to-one unary
c. Many-to-many binary
d. Many-to-many unary



4.




How is this portion of the entity-relationship diagram read, from left to right?