The exhibit shows the Employee and Department Tables.
Based on the definition of these two tables, what happens if a department is deleted from the Department Table
without checking that an employee belongs to the department.

A.
The employee data references a department that does not exist.
B.
SQL returns a referential integrity violation error message.
C.
The employee has no manager to report to.
D.
The employee data is updated automatically to the new department.