We're still actively developing this site. If you encounter any issues, please report them! - Report an issue

DATABASE MANAGEMENT SYSTEMS: DESIGN AND IMPLEMENTATION

COMPSCI 564
Course Description

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.

Prerequisties

COMPSCI/ECE 354 and (COMP SCI 367 or COMPSCI 400 ) or graduate/professional standing or declared in the Capstone Certificate in Computer Sciences for Professionals

Satisfies
Credits

4

Offered

Fall, Spring

Grade Point Average
3.61

10.9% from Historical

Completion Rate
98.91%

1.42% from Historical

A Rate
54.55%

48.19% from Historical

Class Size
275

111.26% from Historical

2025 Fall Grade Distribution

Instructors (2025 Fall)

Sorted by ratings from Rate My Professors

Similar Courses

DATABASE DESIGN FOR INFORMATION PROFESSIONALS

LIS 751

Introduction to contemporary database management systems, the design process employed when implementing databases to solve data and information management problems, developing queries and scripts, and other issues in employing databases to solve organizational information and data challenges.

INTRODUCTION TO DATABASES

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.

APPLIED DATABASE DESIGN

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.

FOUNDATIONS OF DATA MANAGEMENT

COMPSCI 784

Foundational concepts in databases and data management. The first part of the course discusses topics on query languages (conjunctive queries, Datalog), their expressivity and complexity of evaluation. The second part studies advanced topics in modern data management, including data streams, massive parallelism, provenance, uncertain data management and privacy. There are no specific course prerequisites. It is strongly encouraged that the students are familiar with databases and relational algebra (COMP SCI 564or equivalent). Knowledge of algorithms, complexity theory and probability will also be helpful.

TOPICS IN DATABASE MANAGEMENT SYSTEMS

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).