COP 4710 - Fall 2012 - 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
)
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)
Introduction to MySQL
(
pdf version
)
Bike database script from MySQL notes
Introduction to SQL
(
pdf version
)
SQL Practice Problems
(
pdf version
) *** includes relational algebra and tuple calculus solutions to each problem.
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
)
DATA WAREHOUSING (Chapter 25)
Introduction to Data Warehousing
(
pdf version
)
EXAM #1 - Tuesday October 2nd
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 - Thursday November 8th
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 11th - STARTS AT 4:00 PM ! ! !
Final Exam Review Notes
(
pdf version
)
Final Exam Practice Problems
(
pdf version
)
Solutions to Final Exam Practice Problems
(
pdf version
)
Last updated:
November 29, 2012
Return to COP 4710 home page
