COURSE NUMBER AND TITLE: CSCI 3410 Database Systems

CREDIT HOURS: 3

CATALOG DESCRIPTION: Logical and physical database organization, data models, design issues, and secondary storage considerations. Emphasis is on actual participation in the design and implementation of databases.

PREREQUISITE(S): CSCI 1302 with C or better

SUGGESTED TEXT: Elmasri and Navathe, Fundamentals of Database Systems, 5th edition, Addison Wesley, Inc., 2007

COURSE OUTLINE:

  • Database design
  • Entity-relationship and enhanced entity-relationship model
  • Relational database model and constraints
  • Relational algebra and relational calculus
  • Database design by mapping EER diagrams to relations
  • SQL
  • Stored procedures and triggers
  • Functional dependencies
  • Normalization
  • Disk storage
  • File structures
  • Hashing, indexing, dynamic indexing techniques
  • Query processing and optimization.