COP 4710 - SPRING 2008 - 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
)
ERD Notational Differences
(
pdf version
)
CHAPTER 3 - THE RELATIONAL DATA MODEL
The Relational Data Model
(
pdf version
)
CHAPTER 19 - FUNCTIONAL DEPENDENCIES AND NORMALIZATION
Introduction to Functional Dependencies
(
pdf version
)
CHAPTER 4 - RELATIONAL ALGEBRA AND RELATIONAL CALCULUS
Relational Query Languages - Part I - Relational Algebra
(
pdf version
)
Relational Query Languages - Part II - More Relational Algebra and Tuple Calculus
(
pdf version
)
In-class Exercises - Part I
(
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 12 - QUERY PROCESSING
Query Processing
(
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
)
CHAPTER 25 - DATA WAREHOUSING
Introduction to Data Warehousing
(
pdf version
)
EXAM #1 - Monday February 11th
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 - Friday March 28th
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 - Wednesday April 23rd - Starts at 1:00 PM
Final Exam Review Notes
(
pdf version
)
Final Exam Practice Problems
(
pdf version
)
Solutions to Final Exam Practice Problems
(
pdf version
)
Last updated:
April 21, 2008
Return to COP 4710 home page
