Credits:   1 unit (4 credit hours)
Contact Hours:   3 lecture & 3 lab
Instructor:   Professor Joann Ordille
Last Taught:   Fall 2012
Text Book:   Database Systems: the Complete Book, 2nd ed.
By Garcia-Molina, Ullman and Widom. (Prentice Hall, 2008.)
Description:   This course examines the organization, design, and implementation of database management systems. Lecture/laboratory.
Prerequistes:   CS205 (Software Engineering)
Corequisites:   CS202 (Analysis of Algorithms)

Specific Course Goals:

After successfully completing this course, the student will be able to:

  • Develop an understanding of important database design principles with a focus on efficiency and extensibility.
    (ABET/CAC Outcome A)
  • Develop a functional understanding of Structured Query Language (SQL) for the creation and manipulation of databases.
    (ABET/CAC Outcome A)
  • Develop a database management system starting from a set of requirements.
    (ABET/CAC Outcome C)
  • Develop a substantial database design, constructed as a group working over the majority of the semester.
    (ABET/CAC Outcome D)

Student Outcomes:

  ABET/CAC Outcome A   An ability to apply knowledge of computing and mathematics appropriate to the program’s student outcomes and to the discipline.
  ABET/CAC Outcome C   An ability to design, implement, and evaluate a computer-based systems, process, component, or program to meet desired needs.
  ABET/CAC Outcome D   An ability to function effectively on teams to accomplish a common goal.

Topics covered:

  • Entity Relationship Model
  • Functional Dependencies
  • Relational Design
  • Relational Algebra and Normalization
  • Structured Query Language (SQL)
  • Constraints and Triggers
  • XML
  • Indexing and B-trees
  • Transaction, Concurrency, and Recovery
  • Data Warehousing and Data-Mining