COURSE NUMBER AND TITLE: CSCI 3410 Database Systems

CREDIT HOURS: 3

CATALOG DESCRIPTION: This course offers an introduction to database systems as a key concept in information management. The course covers logical and physical database organization, data models, and design issues. Emphasis is on actual participation in the design and implementation of databases.

PREREQUISITE(S): CSCI 1302 with C or better

SUGGESTED TEXT: Fundamentals of Database Systems (6th Edition) by Elmasri and Navathe, Addison Wesley, 2010. ISBN-10: 0136086209

COURSE OUTLINE:

  • 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 and SQL Programming
  • Stored procedures and triggers
  • Normalization