Multiple Choice
The following data are in the tables Employee (primary key: Empno) and Department (primary key: Deptno) . The questions refer to row numbers of this table. The first row of each table is row #1. Empdeptno in table Employee is a foreign key that refers to Deptno in the table Department. Deptmgr in the table Department is a foreign key that refers to Empno in the table Employee.
-The relationship connecting Employee to Department and expressing that an employee is the manager of a department (foreign key: Deptmgr) is:
A) 1-M from Employee to Department
B) 1-M from Department to Employee
C) M-N
D) Self-referencing
Correct Answer:
Verified
Related Questions