A customer has an eCommerce site and imports data into three data extensions daily: Orders, Order_Details, and Products. The data extensions contain the following information:
✑ Orders: OrderID, CustomerID, OrderNumber, OrderDate, OrderTotal, GrandTotal.
✑ Order_Details: ProductID, OrderID, Qty, UnitPrice, ExtendedPrice, Discount.
✑ Products: ProductID, SKU, Name, Description, Cost, Price.
Which two actions should be taken in Data Designer? (Choose two.)
A one-to-many relationship should be created between Orders and Order_Details because each order can have multiple order details. Creating a one-to-one relationship between Orders and Order_Details would be incorrect because it would imply that each order detail is linked to only one order, which is not practical for an eCommerce database. The other options involving one-to-one relationships between Order_Details and Products or between the contact record and Order_Details are unnecessary and do not reflect the relational nature of the data extensions described.
Only a is correct, if order details and products have a one to one relationship, that means one order detail record can only point to one product (which is true) and one product can only ever point back to one order detail record, which is wrong
A&C should be correct as there should be a 1:1 between order_details and products (primary key product id) as products has more information about each product id listed in the order details