Designing the PT Application Data-Services Tier

The Eval database objects are the building blocks of the data services for the Performance Tracking (PT) application. Eval is a Microsoft® SQL Server™ version 7.0 database. All of the transactional data the PT application requires resides in the Table objects. Stored Procedures objects, which are called from PT COM components and ASP pages, act on the database tables. SQL Server View objects allow users to access table data in the Eval database while keeping the data secure from unauthorized persons. The foreign key relationships, constraints, and triggers on the Table objects maintain data integrity in the Eval database, and the Diagrams object shows the relationship between the Eval database tables.

This section describes how the Eval database uses the following new features of SQL Server 7.0:

• Unicode data types support the use of characters from all character sets.
• Filegroups allow you to specify the location of the Eval data files and enhance performance.
• Multiple triggers can be used in INSERT, UPDATE, and DELETE statements.