To support its performance and scalability requirements, the PT application makes extensive use of SQL Server stored procedures that are designed to execute quickly. The stored procedures will not be created until the application is written, and the implementation (see Stored Procedures for the PT Application) and code (see PT Admin Application Stored Procedures) sections include detailed information about the stored procedures the PT application uses. While designing the application, the design team lists the tasks that stored procedures can perform for the PT application, which include database actions that occur when the user adds, changes, or deletes records in the database, and queries that select information from the database to display on the Web pages. The PT application requires the following stored procedures: