DATA AND INFORMATION MANAGEMENT (4 SCU)

Learning outcomes

Each course has been designed to contribute to the attainment of Graduate Competencies. The course
intended learning outcomes (CILO) indicates what students are expected to be able to do by the end of the course, which may cover specific technical skills and personal qualities pertaining to the course given. The personal qualities may have been reflected in the defined course learning outcomes or attained separately, outside the curriculum.
Upon successful completion of this course, students are expected to be able to:
1. Explain and use the advanced SQL programming language in a DBMS environment.
2. Use and develop a distributed DBMSs along with its transaction management and replication techniques.
3. Explain and use Data Warehouse concepts, such as ETL, Data Mart and the dimensional approach.
4. Relate and implement database managements system in the web technology and mobile environment.

Topics

This is an advanced course in Database that covers selected issues related to database such as advanced SQL programming language (SQL/PSM and PL/SQL) , cursor and stored procedure, techniques in transaction management, distributed DBMSs and replication, as well as Data Warehousing concepts. The implementation of web technology and database along with mobile database will also be highlighted at the end of this subject.