You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit.
Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement:
UPDATE QuotationSummary
SET CustomerName = ‘Jean-Paul Deloria’
WHERE QuotationID = 12
When the application executes the statement, the developers receive the following error:
Server: Mrh4403, Level 16, Stats 1, Line 1
View or function ‘QuotationSummary’ is not updateable because it contains aggregates:
You want developers to be able to use this UPDATE statement without generating errors. What should you do？
A．Create an INSTEAD OF trigger on the view to update the composite tables.
B．Grant the developers UPDATE permissions on each base table.
C．Add a cascading update trigger on each base table.
D．Create a QuotationSummary table and populate the table with data from the base tables.
请帮忙给出正确答案和分析，谢谢！
You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit.
Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement:
UPDATE QuotationSummary
SET CustomerName = ‘Jean-Paul Deloria’
WHERE QuotationID = 12
When the application executes the statement, the developers receive the following error:
Server: Mrh4403, Level 16, Stats 1, Line 1
View or function ‘QuotationSummary’ is not updateable because it contains aggregates:
You want developers to be able to use this UPDATE statement without generating errors. What should you do？
A．Create an INSTEAD OF trigger on the view to update the composite tables.
B．Grant the developers UPDATE permissions on each base table.
C．Add a cascading update trigger on each base table.
D．Create a QuotationSummary table and populate the table with data from the base tables.
请帮忙给出正确答案和分析，谢谢！