TCO 2) For the following image, which of the following is TRUE? Orders OrderiD C
ID: 2524457 • Letter: T
Question
TCO 2) For the following image, which of the following is TRUE? Orders OrderiD CustomerID EmployeelD OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Order Details OrderID ProductiD UnitPrice Quantity Discount Image Description: An OrderDetail Table with Primary keys of OrderlD and ProductID and fields of UnitPrice Quantity and Discount is related to an Orders Table that has an infinity symbol on the Order Details Table and a number 1 on the Orders Table. The Orders Table has a Primary key of OrderlD with additional table fields CustomerlD, EmployeelD, OrderDate, REquiredDate, ShipperDate, ShipVia, Freight, ShipName, ShipAddress Ship City, ShipRegion, ShipPostalCode, ShipCountry O The OrderlD field will be unique within both the Orders and Order Details Tables O Within the Orders Table, the OrderlD field may contain more than one of the same value O Within the Order Details Table, the OrderID field may contain more than one of the same value O Within the Orders Details Table, the ProductID field will contain unique values only.Explanation / Answer
the answer is (d) Within the orders table, the ProductID field will contain unique values only because it is a primary key and a primary key should have unique values so that there is no duplication
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.