COP 4710 - Spring 2006 - LECTURE NOTES PAGE
CHAPTER 1 - INTRODUCTION
Introduction to Database Systems
(
.pdf version
)
CHAPTER 2 - CONCEPTUAL DATA MODELING
Introduction to Data Modeling - Part I
(
.pdf version
)
Introduction to Data Modeling - Part II
(
.pdf version
)
CHAPTERS 3 & 4 - THE RELATIONAL DATA MODEL
The Relational Data Model
(
.pdf version
)
Relational Query Languages - Part I - Relational Algebra
(
.pdf version
)
Relational Query Languages - Part II - More Relational Algebra and Tuple Calculus
(
.pdf version
)
CHAPTER 19 - FUNCTIONAL DEPENDENCIES AND NORMALIZATION
Introduction to Functional Dependencies
(
.pdf version
)
Introduction to Normalization
(
.pdf version
)
Introduction to Normalization - Part 3
(
.pdf version
)
CHAPTER 5 - INTRODUCTION TO SQL AND MySQL
Introduction to SQL - Part 1
(
.pdf version
)
Introduction to SQL - Part 2
(
.pdf version
)
Introduction to MySQL - Part 1
(
.pdf version
)
Introduction to MySQL - Part 2
(
.pdf version
)
An Example Commerical SQL Query #1
An Example Commerical SQL QUery #2
An Example Commerical SQL Query #3
CHAPTER 9 - DATA STORAGE
Storage
(
.pdf version
)
CHAPTER 10 - INDEXING AND HASHING
Indexing - Part 1
(
.pdf version
)
Indexing - Part 2
(
.pdf version
)
CHAPTER 12 - QUERY PROCESSING
Query Processing
(
.pdf version
)
CHAPTER 16 - TRANSACTION PROCESSING
Transaction Processing - Part 1
(
.pdf version
)
Transaction Processing - Part 2
(
.pdf version
)
CHAPTER 22 - PARALLEL AND DISTRIBUTED DATABASES
Distributed Database Systems - Part 1
(
.pdf version
)
Distributed Database Systems - Part 2
(
.pdf version
)
Distributed Database Systems - Part 3
(
.pdf version
)
CHAPTERS 25 & 26 - DATA WAREHOUSING AND DATA MINING
Introduction to Data Warehousing - Part 1
(
.pdf version
)
Introduction to Data Warehousing - Part 2
(
.pdf version
)
Introduction to Data Mining
(
.pdf version
)
MID-TERM EXAM - Monday February 27th
Mid-Term Exam Review Notes
(
.pdf version
)
A Few More Practice Problems
(
.pdf version
)
SOLUTIONS to the Practice Problems
(
.pdf version
)
Mid-Term Exam KEY
(
.pdf version
)
FINAL EXAM - Wednesday April 26th - 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 24, 2006
Return to COP 4710 home page
