When the parts have shipped, a table named PartsShipped is updated. When the parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit.
You want the database to update the InStock field automatically. What should you do?
A.Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B.Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C.Use a view that creates an InStock field as part of an aggregate query.
D.Create stored procedures for modifying the PartsShipped and PartsReceived tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsShipped and PartsReceived tables.
第2题
对于青少年配镜,从安全的角度出发,应尽量选用()。
A. 树脂镜片
B. 玻璃镜片
C. 隐性眼镜
第8题
A.从个人层面入手,要求青少年远离网络游戏
B.从家庭层面入手,促进青少年与父母的沟通
C.从学校层面入手,减少青少年课业学习负担
D.从社会层面入手,加强对青少年的道德教育
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!