CS 4400 - Introduction to Database Systems

Spring 2003 - Class Notes

|Main Page|


Notes Used for Lectures:

Notes are in Microsoft Word format except where noted.
Figures from the book can be found at:  ftp://ftp.awl.com/cseng/authors/elmasri/Dbase3e/figures/
You should print out the relevant figures for each class.

  1. Slides on lecture entitled "Emerging Database Technologies and Application Challenges" [ps]
  2. Databases and Database Management(Book Chapters 1, 2) [doc] [doc - With Figures]
  3. Data Modeling Using the Entity-Relationship (ER) Data Model (Book Chapter 3) [doc] [doc - With Figures]
  4. File Organizations and Indexing (Book Chapters 5, 6) [doc]
  5. The Relational Data Model (Book Chapter 7) [doc] [doc - With Figures]
  6. SQL: The Relational Database Standard (Ch.8)[doc]
  7. Mapping ER and EER schemas into the Relational Model (Chapter 9.1, 9.2) [pdf, doc]
  8. Concepts for Object-Oriented Databases (Chapter 11)[ppt]
  9. Theory of Relational Database Design and Normalization(Book Chapter 14 and some of 15) [pdf, doc]
  10. Data Warehousing notes [ppt]


Additional Notes

  1. ER/EER-Model[ppt]


Prof. Mark's Notes on Methodology:

  1. Methodology Concepts [pdf]
  2. Airline Example [ppt]

Last updated: 02.03.2003 by scollins@cc.gatech.edu