You are an enterprise application developer. You are evaluating a database design for a human resource application. The existing database schema meets the following criteria:
The database has an Employee table.
The Employee table has an Employee ID field and several other fields.
You must accommodate the following new requirements:
Employees are either supervisors or line workers.
A supervisor will supervise zero or more line workers. An employee will be supervised by only one supervisor.
A database administrator suggests creating a table named Supervisor and copying the supervisor data from the Employee table to the new table. The database administrator also wants to create a foreign key in the Supervisor table to reference the Employee table. You need to evaluate the suggested change to ensure that there is minimal impact on the existing database schema. What should you conclude?
A.
The suggested schema change will meet the requirements.
B.
The suggested schema change will not meet the requirements. Recommend creating a table named Supervisor and copying the supervisor data from the Employee table to the new table.
Create a foreign key in the Employee table to reference the Supervisor table.
C.
The suggested schema change will not meet the requirements. Recommend creating a column named SupervisorID in the Employee table to reference the supervisor for an employee. Create a foreign key between this column and the Employee table.
D.
The suggested schema change will not meet the requirements. Recommend creating a column named LineWorkerID in the Employee table to reference the line worker for a supervisor. Create a foreign key between this column and the Employee table.