DATABASE MANAGEMENT

Catalog description

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 an industrial-strength database management system. The course will also include coverage of basic database administration tasks and key concepts of data quality and data security. Moreover, students will develop practical skills in the use of SQL for data design, manipulation, interrogation, and application development. In addition to developing database applications, the course helps the students understand how large-scale packaged systems are highly dependent on the use of Database Management Systems (DBMSs). Building on the transactional database understanding, the course provides an introduction to data and information management technologies that provide decision support capabilities under the broad business intelligence umbrella. C-ID: ITIS 180