单选题
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?（）
发布日期：2021-01-28
Create DDL INSERT triggers on the Employee. Task and Assignment entities.
Create CHECK constraints on the Task ID and Employee ID attributes in the Assignment entity.
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.
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.
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
Which command generates a BERT test pattern of alternating ones and zeros on T1 number 1 for one minute？（）
电气化区段微机交流计数电码自动闭塞，微机交流计数轨道继电器的释放值（）。
简述旅行社网络营销手段。
袁隆平不懂电脑，却取得重大发明成就，说电脑上种不出水稻，你对此有什么看法？
根据下面所给的AAA数据库，按照下列每种功能写出相应的Transact-SQL语句或程序段 假设使用名称为AAA的数据库，它包括Students（学号char（8），姓名varchar（8），年龄int，专业varchar（20），入学日期DateTime）和Score（学号char（8），课程名varchar（10），成绩numeric（5，2））两张表。显示出Students表中所有学生记录的学号列的前四个字符。
体内唯一降低血糖的激素是（）
可燃物质在混合物中发生爆炸的最低浓度称为（）。
两岁小儿，体重9kg，生后6个月开始出现，唇发绀，无肺炎史，体格检查见轻度杵状指，胸骨左缘第3肋间闻及Ⅲ收缩期喷射性杂音，肺动脉瓣区第二音单一响亮。X线胸片示心影呈"靴型"、二肺清晰透亮。该小儿最可能的诊断是（）。
简述计划指导在计划经济体制时期和市场经济背景下的重大区别。
试述纵马分腿腾越的教学步骤。
暂无相关推荐~
You are a database developer. You plan to design a database solution byusing SQL...
You plan to take a closed database backup using operating system commands. Which...
You plan to use static database registration for a new listener when you create ...
You are designing a performance monitoring plan for the database that supports A...
You want to perform in incomplete recovery of your database. You plan to use th...
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i data...
You are managing the APPPROD database as a DBA. You plan to duplicate this datab...
You plan to use the In Database Archiving feature of Oracle Database 12c, and st...
You plan to use static database registration for a new listener when you create ...
In your production database， you have multiple resource plan directives that ref...