You are a database developer. You plan to design a database solution byusing SQL Server 2008. You are creating adataba seto 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, thetask is deleted. When a task is deleted, the associated assignment is deleted. When an employee is nolonger available tocomple tea task, theemployee 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 DDL INSERT triggers on the Employee. Task and Assignment entities.B.Create CHECK constraints on the Task ID and Employee ID attributes in the Assignment entity.C.Create Foreign Keys constraints on the Task ID and EmployeeID attributes in the Assignment entity. Reference the Task and Employee entities respectively. Specify the appropriate On Delete action.D.Create Foreign Keys constraints on the Task ID and Employee ID attributes in theTask and Employeeentities respectively. Reference the Assignment entity, and specify the appropriate On Delete action.

单项选择题

You are a database developer. You plan to design a database solution byusing SQL Server 2008. You are creating adataba seto 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, thetask is deleted. When a task is deleted, the associated assignment is deleted. When an employee is nolonger available tocomple tea task, theemployee 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 DDL INSERT triggers on the Employee. Task and Assignment entities.
B.Create CHECK constraints on the Task ID and Employee ID attributes in the Assignment entity.
C.Create Foreign Keys constraints on the Task ID and EmployeeID attributes in the Assignment entity. Reference the Task and Employee entities respectively. Specify the appropriate On Delete action.
D.Create Foreign Keys constraints on the Task ID and Employee ID attributes in theTask and Employeeentities respectively. Reference the Assignment entity, and specify the appropriate On Delete action.

相关考题

多项选择题 Youneedtocreateacolumnthatallowsyoutocreateauniqueconstraint.Whichtwo column definitionsshouldyou choose?（）

多项选择题 You are adatabase solutions architect.Your company plans to develop asolution by using a SQLServer 2008 instance. The solutionhas the following business requirements: Import datafromvarious datasources suchas MicrosoftOffice Excel, Microsoft SQL Server2000, Microsoft SQL Server 2005, and CSV files. Profile the source data before it is imported. Provide collaboration andoffline capabilities to mobile users. Allowmobile users to use heterogeneous data stores. You need to configure the appropriate SQL Server components to accomplish the business requirements. You want to achieve this goal by using the minimum amount of administrative effort. Which two SQL Server components should you use?（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

MCITP(70-454)