Solved

Use the Following Tables to Answer the Next Questions  CustCode  InvNo  EmpCode  InvDate \begin{array}{|l|l|l|l|}\hline \text { CustCode } & \text { InvNo } & \text { EmpCode } & \text { InvDate } \\\hline\end{array}

Question 33

Multiple Choice

Use the following tables to answer the next questions. Neither the order in which the data elements are presented in these tables nor the capitalization of the names of the data elements has any significance.Invoice TableInvoice Line TableInventory TableEmployee TableCustomer Table
Invoice Table
 CustCode  InvNo  EmpCode  InvDate \begin{array}{|l|l|l|l|}\hline \text { CustCode } & \text { InvNo } & \text { EmpCode } & \text { InvDate } \\\hline\end{array}
Invoice Line Table
 Qty  InvNo  ProdNo \begin{array}{|l|l|l|}\hline \text { Qty } & \text { InvNo } & \text { ProdNo } \\\hline\end{array}
Inventory Table
 ProdNo  Desc  Price \begin{array}{|l|l|l|}\hline \text { ProdNo } & \text { Desc } & \text { Price } \\\hline\end{array}
Employee Table
 EmpName  EmpCode  CommRate \begin{array}{|l|l|l|}\hline \text { EmpName } & \text { EmpCode } & \text { CommRate } \\\hline\end{array}
Customer Table
 Name  City  CustCode \begin{array}{|l|l|l|}\hline \text { Name } & \text { City } & \text { CustCode } \\\hline\end{array}
-Which of the following data elements serves as both a primary and a foreign key in the five tables above?


A) InvNo
B) CustCode
C) EmpCode
D) A and B, but not C
E) A, B, and C E

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions