DATABASE DESIGN FOR INFORMATION PROFESSIONALS

COMPSCI 564

What a database management system is; different data models currently used to structure the logical view of the database: relational, hierarchical, and network. Hands-on experience with relational and network-based database systems. Implementation techniques for database systems. File organization, query processing, concurrency control, rollback and recovery, integrity and consistency, and view implementation.

LIS 711

Preparation to effectively and ethically manage, organize and protect the data in organizational settings. Covers major topics of data management addressed by the Certified Data Management Professional certification. Assess, construct and implement workflows, organizational policies and data architecture to improve data quality and security. Learn to clean and organize data for effective retrieval and use. Learn tools and techniques to support data interoperability, and gain understanding of contemporary data management ethical and policy issues.

COMPSCI 764

Implementation of database management systems, the impact of new technology on database management systems, back-end database computers, distributed database management systems, concurrency control, and query execution in both distributed and centralized systems, implementation of multiple user views, roll-back and recovery mechanisms, database translation. Students are strongly encouraged to have knowledge of database design (e.g.,COMP SCI 564).

INFOSYS 322

Introduction to database management systems with a focus on relational databases. Covers designing, creating, populating, managing, and retrieving data from databases. SQL will be used with a focus on querying for business applications and intelligence, data retrieval for summary reports, and data visualization. Offers a brief introduction to non-relational databases for business applications.

LIS 464

Introduces the applications of databases to real-world data and information problems. Overview of the principles and practices of user-oriented database design, management, and application. Discussion and practice cover database application lifecycle, data modeling, relational database design, SQL queries, reports and other interfaces to database data, and database documentation.