The structural schema is built using SQL2's DDL and the completed intelligent database. The manipulation schema is built using Oracle's stored procedures, functions, and packages. The integrity schema is completed using triggers. A methodology and classification of triggers are presented. Preregistration is required.
Course is limited in size.
Stored procedures and triggers are also introduced. Preregistration is required. Course is limited in size. Verification processes and procedures are discussed with emphasis on software inspections, metrics, and configuration management. Validation processes and procedures are reviewed with emphasis on unit testing, integration testing, validation testing, and metrics.