题目内容
（请给出正确答案）
[主观题]
You are the administrator of a SQL Server 2000 computer. The server contains a database na
med inventory. The database has a Parts table that has a field named InStock. When parts are shipped, a table named PartsShipped is updated. When Parts are received, a table names PartsReceived is updated. The relationship of these tables is shown in the exhibit.
.jpg)
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 those calculations that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C．Use a view that creates an InStock as a part of an aggregate query.
D．Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock fielding the parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables.
如搜索结果不匹配，请 联系老师 获取答案
