You are an enterprise application developer. You are designing an application. The database for the application currently has a one-to-one relationship between order and product. The application must meet the following business requirements:
An order must contain orders for many products.
An order must store the ordered quantity of each product.
You need to evaluate the existing design and recommend changes to meet the business requirements.
Which two changes should you recommend? (Each correct answer presents a complete solution.
Choose two.)
A.
Change the relationship between order and product to one-to-many.
B.
Change the relationship between order and product to many-to-many.
C.
Create a new table named Order line. Establish a one-to-many relationship between order and Order line and a one-to-one relationship between product and Order line.
D.
Create a new table named Order line. Establish a one-to-many relationship between order and Order line and a one-to-many relationship between product and Order line.