Case-Based Critical Thinking Questions
Case 9-3
Taylor manages a database for a regional hardware enterprise with 10 stores in 2 states. The hardware store wholesales to contractors. The database includes these tables (among others): tblContractor, tblProducts, tblBilling, tblInvoices.
-Taylor has added the tables tblContractor, tblBilling, and tblInvoices to the relationships window. He has created a relationship between the tblBilling and tblContractor based on the ContractorID field. What type of relationship is this?
A)one-to-one
B)one-to-many
C)many-to-many
D)one-to-none

Question

Case-Based Critical Thinking Questions
Case 9-3
Taylor manages a database for a regional hardware enterprise with 10 stores in 2 states.  The hardware store wholesales to contractors. The database includes these tables (among others): tblContractor, tblProducts, tblBilling, tblInvoices.
-Taylor has added the tables tblContractor, tblBilling, and tblInvoices to the relationships window. He has created a relationship between the tblBilling and tblContractor based on the ContractorID field.  What type of relationship is this?
A)one-to-one
B)one-to-many
C)many-to-many
D)one-to-none

Quizplus · Accepted Answer

The Answer of Case-Based Critical Thinking Questions
Case 9-3
Taylor manages a database for a regional hardware enterprise with 10 stores in 2 states.  The hardware store wholesales to contractors. The database includes these tables (among others): tblContractor, tblProducts, tblBilling, tblInvoices.
-Taylor has added the tables tblContractor, tblBilling, and tblInvoices to the relationships window. He has created a relationship between the tblBilling and tblContractor based on the ContractorID field.  What type of relationship is this?
A)one-to-one
B)one-to-many
C)many-to-many
D)one-to-none