Each row of the table Department describes a department. Deptno is the primary key. Deptmgr (Department manager) refers to Empno in table Employee.
Each row of the table Project describes a project. The primary key is Projno. Projmgr (project manager. refers to Empno in the table Employee.
The table Projstaff indicates the staff assigned to various Projects.
The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate
keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.
-Which of the following columns is not a foreign key?
A) Projno in table Project
B) Projmgr in table Project
C) Prstno in table Projstaff
D) Prstempno in table Projstaff
Correct Answer:
Verified
Q33: A candidate key is indicated in SQL
Q34: To perform a difference operation on two
Q35: An unknown value,or a value that does
Q36: Only a limited number of simple statistical
Q37: The following data are in the
Q39: A divide operator is used to retrieve
Q40: The primary key of a table is
Q41: A relationship in which a foreign key
Q42: The _ rule states that each table
Q43: The tables Dept1 and Dept2
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents