Use the database tables below to answer the following questions.
-Which of the relationships below is a many-to-many relationship?
A)CUSTOMERS, SALES ORDERS
B)SALES ORDERS, ITEMS
C)ITEMS, SO LINE
D)SO LINE, CUSTOMERS

Question

Use the database tables below to answer the following questions. 
-Which of the relationships below is a many-to-many relationship?
A)CUSTOMERS, SALES ORDERS 
B)SALES ORDERS, ITEMS 
C)ITEMS, SO LINE 
D)SO LINE, CUSTOMERS

Quizplus · Accepted Answer

The SALES ORDERS table has a many-to-many relationship with the ITEMS table through the intermediary table SO LINE. Each sales order can have multiple items, and each item can be associated with multiple sales orders. The other relationships are one-to-many relationships: a customer can have multiple sales orders, but each sales order belongs to one customer (A); a sales order can have multiple SO LINES, but each SO LINE belongs to one sales order (C); and a SO LINE belongs to one sales order, but a customer can have multiple sales orders (D).

Use the Database Tables Below to Answer the Following Questions