CMSC 206

COURSE CODE: CMSC 206

COURSE TITLE: Database Management Systems 

SEMESTER OFFERED: First Semester

PREREQUISITES: CMSC 204 or COI

COURSE DESCRIPTION: Design and implementation of database management systems; relational database and query optimization; and future trends in database designs

COURSE GOAL:

After completing this course, you should be able to:

  • Teach students the concepts of database management systems.

COURSE OUTLINE:

  • Fundamental Database Concepts
  • Database Models
  • Basic DBMS Functions
  • Transaction Processing and Concurrency Control
  • Database Integrity and Crash Recovery
  • Conceptual Design
  • Logical Design
  • Normalization
  • Relational Algebra
  • SQL Queries
  • Software System Design
  • Database Trends