DATA AND INFORMATION MANAGEMENT (4 SCU)

Learning Outcomes :

Upon successful completion of this course, students are expected to be able to: Explain the role of databases in organizations and information systems, Apply SQL language to construct, secure and access the database in a DBMS environment, Use formal languages associated with the relational database model, including relational algebra, and relational calculus, Develop a relational database with a set normalized relations using database design methodology three main phases: conceptual, logical, and physical design that support the data requirements of an enterprise, Develop a distributed DBMSs along with its transaction management and replication techniques, Use database management system in the web technology and mobile environment.

Topics :

This course introduces the concept of information modeling, which emphasizes the importance of grouping the information into specific categories before it is transferred to the actual database design. Later in this course, an implementation phase is discussed to ensure the students are well aware of any implications that might develop from improper information modeling. In addition, this course also aims to introduce students to the concept of database design by predicting the use of future retrieval systems. Students understand that both a consideration of the data model and awareness of the retrieval system to be applied are required in designing a database. Consequently, new concepts are introduced, such as query processing and optimization, transaction processing concepts, and concurrency control techniques. This will lead students to understand the method of database tuning, functional dependencies, and normalization for RDB that will help them to understand further courses. This course also covers selected issues related to databases such as advanced SQL programming language (SQL/PSM and PL/SQL), cursor and stored procedures, techniques in transaction management, distributed DBMSs and replication, as well as data-warehousing concepts. The implementation of web technology and databases along with mobile databases will also be highlighted.

Prerequisite (s) : Research Methods in Information Systems; Introduction to Database Systems