You are a database developer. You plan to design a database solution by using SQL Server
2008. You are creating a database to support the office manager. Your database model has
the following structure. The database design has the following business requirements: ·An
employee can be assigned more than one task. ·Upon completion, the task is deleted.
·When a task is deleted, the associated assignment is deleted. ·When an employee is no
longer available to complete a task, the employee link to the assignment is replaced with a
NULL value. You need to implement the business requirements to maintain data integrity.
What should you do?
A.
Create Foreign Keys constraints on the TaskID and EmployeeID attributes in the
Assignment entity. Reference the Task and Employee entities respectively. Specify the
appropriate On Delete action.
B.
Create Foreign Keys constraints on the TaskID and EmployeeID attributes in the Task
and Employee entities respectively. Reference the Assignment entity, and specify the
appropriate On Delete action.
C.
Create DDL INSERT triggers on the Employee, Task, and Assignment entities.
D.
Create CHECK constraints on the TaskID and EmployeeID attributes in the Assignment
entity.