Examlex

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?


Definitions:

Related Questions