COP 4710 - Spring 2013 - 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
)
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 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
)
EXAM #1 - Tuesday February 12th
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 April 4th
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 April 30th - STARTS AT 1:00 PM ! ! !
Final Exam Review Notes
(
pdf version
)
UPDATED April 25th
Final Exam Practice Problems
(
pdf version
)
Solutions to Final Exam Practice Problems
(
pdf version
)
Last updated:
April 18, 2013
Return to COP 4710 home page
