You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application contains the following components:
– A business tier component
– A data access tier component
– A Microsoft SQL Server database
The database stores sales order data. You plan to design a validation strategy that meets the following requirements:
– For each order, the ship date must be greater than the order date.
– Validation errors must be detected as early as possible.
– Validation must be enforced regardless of which applications or application components modify the order data.
You need to ensure that the validation strategy meets the specified requirements. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)
A.
Create a trigger.
B.
Create a CHECK constraint.
C.
Create a DEFAULT constraint.
D.
Implement the validation logic in a business tier code.
E.
Implement the validation logic in a data access tier code.