What should you do?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application stores human resources data in a Microsoft SQL Server 2008 database. A partial database schema is as shown in the exhibit. (Refer to the Exhibit.) Each time a row is added, modified, or deleted from the Employee table, a corresponding entry must be recorded in the EmployeeChangeLog table. You need to implement the data change logging. What should you do?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application stores human resources data in a Microsoft SQL Server 2008 database. A partial database schema is as shown in the exhibit. (Refer to the Exhibit.) Each time a row is added, modified, or deleted from the Employee table, a corresponding entry must be recorded in the EmployeeChangeLog table. You need to implement the data change logging. What should you do?

A.
Create a trigger on the Employee table.

B.
Add a user-defined function to the database.

C.
Add a CHECK constraint to the Employee table.

D.
Create a foreign key on the EmployeeChangeLog table that references the Employee table.



Leave a Reply 0

Your email address will not be published. Required fields are marked *