COP 4710 - Spring 2004 - LECTURE NOTES PAGE
INTRODUCTION
Introduction to Database Systems (Day 2: January 7)
(
.pdf version
)
Introduction to Database Systems - Part 2 (Day 3: January 12)
(
.pdf version
)
CONCEPTUAL DATA MODELING
Introduction to Data Modeling - Part I (Day 4: January 14)
(
.pdf version
)
Introduction to Data Modeling - Part II (Day 5: January 21)
(
.pdf version
)
THE RELATIONAL DATA MODEL
The Relational Data Model (Day 6: January 26)
(
.pdf version
)
Relational Query Languages - Part I - Relational Algebra (Day 7: January 28)
(
.pdf version
)
Relational Query Languages - Part II - More Relational Algebra and Tuple Calculus (Day 8: February 2)
(
.pdf version
)
FUNCTIONAL DEPENDENCIES AND NORMALIZATION
Introduction to Functional Dependencies (Day 9: February 4)
(
.pdf version
)
Introduction to Normalization (Day 10: February 9)
(
.pdf version
)
Introduction to Normalization - Part 2 - (Day 11: February 11)
(
.pdf version
)
Introduction to Normalization - Part 3 - (Day 12: February 16)
(
.pdf version
)
Introduction to Normalization - Part 4 - (Day 13: February 18)
(
.pdf version
)
MID-TERM EXAM - Wednesday February 25th
Mid-Term Exam Review Notes - (Day 14: February 23rd)
(
.pdf version
)
A Few More Practice Problems - (Day 14: February 23rd)
(
.pdf version
)
SOLUTIONS to the Practice Problems - (Day 14: February 23rd)
(
.pdf version
)
Mid-Term Exam KEY
(
.pdf version
)
INTRODUCTION TO ACCESS AND SQL
Introduction to Microsoft Access (Day 16: March 1)
(
.pdf version
)
Introduction to SQL (Day 17: March 3)
(
.pdf version
)
Introduction to SQL - Part 2 (Day 18: March 15)
(
.pdf version
)
Introduction to SQL - Part 3 (Day 19: March 17)
(
.pdf version
)
Introduction to SQL - Part 4 (Day 20: March 22)
(
.pdf version
)
QUERY PROCESSING AND OPTIMIZATION
Query Optimization (Day 21: March 24)
(
.pdf version
)
Query Optimization - Part 2 (Day 22: March 29)
(
.pdf version
)
TRANSACTION PROCESSING
See last part of Day 22 notes above for introductory material
Transaction Processing (Day 23: March 31)
(
.pdf version
)
Concurrency Protocols (Day 24: April 5)
(
.pdf version
)
DATA WAREHOUSING AND DATA MINING
Introduction to Data Warehousing (Day 25: April 7)
(
.pdf version
)
Introduction to Data Warehousing - Part 2 (Day 26: April 12)
(
.pdf version
)
Introduction to Data Mining (Day 27: April 14)
(
.pdf version
)
FINAL EXAM - Wednesday April 21st
Final Exam Review Notes - (Day 28: April 19th)
(
.pdf version
)
Final Exam Practice Problems - (Day 28: April 19th)
(
.pdf version
)
Solutions to Final Exam Practice Problems - (Day 28: April 19th)
(
.pdf version
)
Last updated:
Monday April 19, 2004
Return to COP 4710 home page
