COP 4710 - FALL 2007 - LECTURE NOTES PAGE


CHAPTER 1 - INTRODUCTION
  • Introduction to Database Systems( pdf version )


  • CHAPTER 2 - CONCEPTUAL DATA MODELING
  • Introduction to Data Modeling ( pdf version )
  • In-class Exercises ( pdf version )


  • CHAPTER 3 - THE RELATIONAL DATA MODEL
  • The Relational Data Model ( pdf version )
  • In-class Exercises ( pdf version )


  • CHAPTER 4 - RELATIONAL ALGEBRA AND RELATIONAL CALCULUS
  • Relational Query Languages - Part I - Relational Algebra ( pdf version )
  • In-class Exercises - Part I ( pdf version )
  • Relational Query Languages - Part II - More Relational Algebra and Tuple Calculus ( pdf version )
  • In-class Exercises - Part II ( pdf version )


  • CHAPTER 5 - INTRODUCTION TO SQL AND MySQL
  • Introduction to SQL - Part 1 ( pdf version )
  • Introduction to SQL - Part 2 ( pdf version )
  • SQL - In Class Exercises ( pdf version ) *** includes relational algebra and tuple calculus solutions to each problem.
  • Introduction to MySQL ( .pdf version )
  • Bike database script from MySQL notes


  • CHAPTER 19 - FUNCTIONAL DEPENDENCIES AND NORMALIZATION
  • Introduction to Functional Dependencies ( pdf version )


  • CHAPTER 9 - DATA STORAGE
  • Storage ( pdf version )


  • CHAPTER 10 & CHAPTER 11 - INDEXING AND HASHING
  • Indexing & Hashing ( pdf version )


  • CHAPTER 16 & CHAPTER 17 - TRANSACTION PROCESSING
  • Transaction Processing ( pdf version )


  • CHAPTER 22 - PARALLEL AND DISTRIBUTED DATABASES
  • Distributed Database Systems ( pdf version )



  • EXAM #1 - Thursday September 20th
  • Exam #1 Review Notes ( .pdf version )
  • A Few More Practice Problems ( pdf version )
  • SOLUTIONS to the Practice Problems ( pdf version )
  • Exam #1 KEY ( pdf version )

  • EXAM #2 - Tuesday November 6th
  • Exam #2 Review Notes ( .pdf version )
  • A Few More Practice Problems ( pdf version )
  • SOLUTIONS to the Practice Problems ( pdf version )
  • Exam #2 KEY ( pdf version )

  • FINAL EXAM - Thursday December 6th - Starts at 4:00 PM
  • Final Exam Review Notes ( pdf version )
  • Final Exam Practice Problems ( pdf version )
  • Solutions to Final Exam Practice Problems ( pdf version )


  • Last updated: November 29, 2007

    Return to COP 4710 home page