COP 4710 - Fall 2013 - LECTURE NOTES PAGE

INTRODUCTION (Chapter 1)
  • Introduction to Database Systems( pdf version )


    • CONCEPTUAL DATA MODELING (Chapter 2)
  • Introduction to Data Modeling - Part 1 - The Data Models ( pdf version )
  • Introduction to Data Modeling - Part 2 - The ER Model ( pdf version )
  • In-class Exercises ( pdf version )


    • LOGICAL DATA MODELING AND THE RELATIONAL DATA MODEL (Chapter 3)
  • Logical Data Modeling And The Relational Data Model ( pdf version )
  • In-class Exercises ( pdf version )


    • RELATIONAL ALGEBRA AND RELATIONAL CALCULUS (Chapter 4)
  • Relational Query Languages - Part I - Relational Algebra (The Five Fundamental Operators) ( pdf version )
  • In-class Exercises - Part I ( pdf version )
  • Relational Query Languages - Part II - Relational Algebra (The Redundant Operators) and Tuple Calculus ( pdf version )
  • In-class Exercises - Part II ( pdf version )


    • INTRODUCTION TO SQL AND MySQL (Chapter 5)

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


    • QUERY PROCESSING
  • Query Processing And Optimization ( pdf version )


    • DATA STORAGE AND FILE SYSTEMS
  • Storage ( pdf version )
  • Indexing & Hashing ( pdf version )


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


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


    • EXAM #1 - Tuesday September 24th
  • Exam #1 Review Notes ( pdf version )
  • A Few Practice Problems ( pdf version )
  • SOLUTIONS to the Practice Problems ( pdf version )
  • Exam #1 KEY ( pdf version )
    • EXAM #2 - Tuesday November 5th
  • 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 - Tuesday December 10th - STARTS AT 4:00 PM ! ! !
  • Final Exam Review Notes ( pdf version )   UPDATED November 25th
  • Final Exam Practice Problems ( pdf version )
  • Solutions to Final Exam Practice Problems ( pdf version )

    • Last updated: November 19, 2013

    Return to COP 4710 home page