CSC 440 - Database Management Systems

Catalog Description:

Introduction to database concepts. This course examines the logical organization of databases: the entity-relationship model; the relational data model and its languages. Functional dependencies and normal forms. Design, implementation, and optimization of query languages; security and integrity, concurrency control, transaction processing, and distributed database systems.

Contact Hours: Prerequisites: CSC 316 or ECE 309
Co-requisites: None
Restrictions: None
Coordinator: Dr. Rada Chirkova
Textbook: Database Systems

Course Outcomes:
Upon successful completion of this course, a student will be able to…

  1. design and edit entity-relationship (E/R) diagrams for database schemas
  2. translate E/R diagrams into relational schemas
  3. determine the normalization status of relational schemas and decompose schemas into 3NF and/or BCNF
  4. understand, design, and evaluate relational-algebra queries on a given relational schema
  5. understand, design, and evaluate SQL queries on a given relational schema
  6. understand, design, and evaluate constraints and triggers on a given relational schema
  7. understand and design SQL code for transactions, security, and user authorization in relational database systems
  8. understand and explain algorithms for coping with database-system failures
  9. understand and explain algorithms for concurrency control in database systems
  10. write, test, and deploy application programs in database-system environments


See Course Listings

See Course Coordinators