Refer to the exhibit.
A data architect is loading the tables and a synth key is generated.
How should the data architect resolve the synthetic key?
Remove the LineNo field from Shipments and use the AutoNumber function on the
Create a composite key using OrdertD and LineNo
Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments
Submit