COP 4710 - Fall 2011 - LECTURE NOTES PAGE
INTRODUCTION (Chapter 1)
Introduction to Database Systems
(
pdf version
)
CONCEPTUAL DATA MODELING (Chapter 2)
Introduction to Data Modeling
(
pdf version
)
In-class Exercises
(
pdf version
)
THE RELATIONAL DATA MODEL (Chapter 3)
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
)
Relational Query Languages - Part II - Relational Algebra (The Redundant Operators) and Tuple Calculus
(
pdf version
)
INTRODUCTION TO SQL AND MySQL (Chapter 5)
Introduction to MySQL
(
.pdf version
)
Bike database script from MySQL notes
Introduction to SQL
(
pdf version
)
SQL - In Class Exercises
(
pdf version
) *** includes relational algebra and tuple calculus solutions to each problem.
FUNCTIONAL DEPENDENCIES AND NORMALIZATION (Chapter 19)
Introduction to Functional Dependencies
(
pdf version
)
DATA STORAGE AND FILE SYSTEMS
Storage
(
pdf version
)
Indexing & Hashing
(
pdf version
)
QUERY PROCESSING
Query Processing And Optimization
(
pdf version
)
TRANSACTION PROCESSING (Chapters 16 & 17)
Transaction Processing
(
pdf version
)
PARALLEL AND DISTRIBUTED DATABASES (Chapter 22)
Distributed Database Systems
(
pdf version
)
DATA WAREHOUSING (Chapter 25)
Introduction to Data Warehousing
(
pdf version
)
EXAM #1 - Tuesday September 27th
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 1st
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 6th - Starts at 4:00 PM
Final Exam Review Notes
(
pdf version
) * * * UPDATED 12/5/2011
Final Exam Practice Problems
(
pdf version
)
Solutions to Final Exam Practice Problems
(
pdf version
)
Last updated:
December 1, 2011
Return to COP 4710 home page
