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 ​