IST 27000 - Data And Information Management

This course provides the students with an introduction to the core concepts in data and information management. It is centered around the core skills of identifying organizational information requirements, modeling them using conceptual data modeling techniques, converting the conceptual data models into relational data models and verifying its structural characteristics with normalization techniques, and implementing and utilizing a relational database using a database management system. This course will also include coverage of basic database administration tasks, how large-scale packaged systems are highly dependent on the use of a Database Management System (DBMS) and data and information management technologies.

Preparation for Course
P: IST 16000 or BUS 32100.

Cr. 3.
Student Learning Outcomes
1.   Learn to understand the role of databases and database management systems in managing organizational data and information.
2.   Learn to understand the historical development of database management systems and logical data models.
3.   Understand the role of information requirements specification processes in the broader systems analysis and design context.
4.   Learn to use at least one conceptual data modeling technique (such as entity-relationship modeling) to capture the information requirements for an enterprise domain.
5.   Learn to link to each other the results of data/information modeling and process modeling.
6.   Learn to design high-quality relational databases.
7.   Learn to understand the purpose and principles of normalizing a relational database structure and to design a relational database so that it is at least in 3NF.
8.   Learn to implement a relational database design using an industrial-strength database management system, including the principles of data type selection and indexing.
9.   Learn to use the data definition, data manipulation, and data control language components of SQL in the context of one widely used implementation of the language.
10.  Learn to perform simple database administration tasks.
11.  Learn the concept of database transaction and apply it appropriately to an application context.
12.  Learn to understand the basic mechanisms for accessing relational databases from various types of application development environments.
13.  Learn to understand the role of databases and database management systems in the context of enterprise systems.
14.  Learn to understand the difference between on-line transaction processing (OLTP) and online analytic processing (OLAP), and the relationship between these concepts and business intelligence, data warehousing and data mining.
15.  Learn to create a simple data warehouse (“data mart”).
16.  Learn to understand how structured, semi-structured, and unstructured data are all essential elements of enterprise information and knowledge management. In this context, the students will learn the principles of enterprise search.