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.
-The relationship connecting Employee to Project and expressing that an employee works on a project (Link table Projstaff) is:
A) 1-M from employee to project
B) 1-M from project to employee
C) M-N
D) Self-referencing
Correct Answer:
Verified