This course covers aspects of the physical design, implementation and data base performance analysis for business applications. Students will learn to develop physical database requirements from Logical Designs, and to analyze query processing performance of the physical implementations. In addition to weekly labs the course will include a design project which will help students to develop competence with standard database definition (DDL/SQL)and procedural languages (PL/SQL) for defining physical schemas and developing stored procedures, triggers and user functions. The course will utilize state of the art data base design tools and relational database software. Lect: 2 hrs./Lab: 1 hr. Prerequisite: ITM 500 or Direct Entry Course Weight: 1.00 Billing Units: 1
