Ask Question

Which column or columns in each table should be defined as the primary key?

+1
Answers (1)
  1. 26 October, 09:48
    0
    The question is incomplete as there is no options given;

    the complete question with options is;

    Which column or columns in each table should be defined as the primary key?

    a. Orders: OrderID; OrderLineItems: OrderID, OrderSequence, andProductID; Products: ProductID and ProductName

    b. Orders: OrderID; OrderLineItems: OrderID and OrderSequence; Products: ProductID

    c. Orders: OrderID and OrderDate; OrderLineItems: OrderID andOrderSequence; Products: ProductID

    d. Orders: OrderID; OrderLineItems: OrderID; Products: ProductID

    Answer:

    the correct option from the given options is, "b", Orders: OrderID; OrderLineItems: OrderID and OrderSequence; Products: ProductID

    when you are going to create a primary key, In Object Explorer, right-click the table to which you want to add a unique constraint, and then click Design. In Table Designer tab, click the row selector for the database column you want to define as the primary key.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Which column or columns in each table should be defined as the primary key? ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers