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?

Question

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?

Accepted Answer

C. Create Foreign Keys constraints on the TaskID and EmployeeID attributes in the Assignment

Answer

A. Create DDL INSERT triggers on the Employee, Task, and Assignment entities.

Answer

B. Create CHECK constraints on the TaskID and EmployeeID attributes in the Assignment entity.

Answer

D. Create Foreign Keys constraints on the TaskID and EmployeeID attributes in the Task and

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…

Question

Options

How the community answered

Community Discussion