CAP - Computer Applications
(Offered fall). Prerequisites: ISM4214 or COP2701 with a minimum grade of "C." Prerequisite or corequisite: MAN3303. This course provides an introduction to data warehousing concepts, requirements gathering, design and implementation. Students learn about operational database integration, extraction, transformation, loading of data to historical database system such as operational data store and data warehouse. Students are provided with techniques for the analysis, design, denormalization,implementation, utilization, and documentation in the development of data warehouse systems. Structure query language for database and data warehouse will be studied and used to retrieve data and manipulate the information from the implemented databases. Students are required to complete and present a project to class in the data warehousing area.