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.