Database Systems

Text Book

​Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom.  Database Systems. The Complete Book.  Second Edition.  Pearson Prentice Hall. 2009.

Course Synopsis

This course is designed to introduce students to the foundations of database systems, focusing on topics such as relational algebra, relational database design, entity-relationship diagrams, SQL, setting up database triggers, constraints, indexes and views, data warehouse principles, basics of NoSQL databases and Big Data concepts.  Students completing the course will have experience with current database technologies, and the ability to use and develop databases. 

Topic Sequence (May be modified if necessary)

  • Introduction to Database Systems - Ch. 1    
  • Relational Model - Ch. 2 (till 2.3)    
  • Relational Algebra - rest of Ch. 2 & Ch. 5 through 5.2    
  • E R Model - Ch. 4    
  • E R Model to relational Design - Ch. 4 (most likely skipping 4.7 to end of Chapter) 
  • Relational Database Design - Ch. 3    
  • SQL - Ch. 6    
  • SQL Constraints & Triggers - Ch. 7    
  • Views & Indexes - Ch. 8    
  • Data Warehousing
  • NoSQL databases and Mongo DB 
  • Big Data Concepts

Course Structure

(Changes due to COVID-19)

  • All classes will be conducted synchronous online using Zoom
  • All classes will be recorded. Recording will be shared in ICON only to registered students in the class. Please review the CLAS syllabus insert, with additional video information: 

  • All exams will be online. We are checking if we can use remote proctoring tools Proctorio or Respondus. I will share more information related to exams when we get closer to the midterm. 
  • Office hours will be through zoom - I will use the waiting room feature so that I can interact with each student individually.
  • We will use the zoom participant list to take attendance. Please use your class registered name as label while logging in to zoom.