CGS 2545 - SPRING 2012 - LECTURE NOTES PAGE
INTRODUCTION
Introduction to Database Systems
(
pdf version
)
THE DATABASE DEVELOPMENT PROCESS (Chapter 1)
The Database Development Process
(
pdf version
)
MODELING DATA IN THE ORGANIZATION (Chapter 2)
Modeling Data In The Organization
(
pdf version
)
In-class Exercises
(
pdf version )
THE EER MODEL AND BUSINESS RULES (Chapter 3)
EER Model and Business Rules
(
pdf version
)
In-class Exercises
(
pdf version )
LOGICAL DATABASE DESIGN AND THE RELATIONAL MODEL (Chapter 4)
Part 1: Transforming ER Diagrams Into Relational Schemas
(
pdf version
)
Chapter 4: In-class Exercises - For Part 1
(
pdf version )
Part 2: Normalization
(
pdf version
)
INTRODUCTION TO SQL (Chapter 6)
Introduction to SQL
(
pdf version
)
SQL In Class Exercises - Basic SQL
(
pdf version
)
ADVANCED SQL (Chapter 7)
Advanced SQL
(
pdf version
)
SQL In Class Exercises
(
pdf version
)
DATA AND DATABASE ADMINISTRATION (Chapter 11)
Data and Database Administration
(
pdf version
)
DISTRIBUTED DATABASE SYSTEMS (Chapter 12)
Distributed Database Management Systems
(
pdf version
)
EXAM #1 - Friday February 24th
Exam #1 Review Notes
(
pdf version
)
Exam #1 KEY
(
pdf version
)
EXAM #2 - Monday April 2nd
Exam #2 Review Notes
(
pdf version
)
Exam #2 KEY
(
pdf version
)
FINAL EXAM - Friday April 27th - Starts at 10:00 AM
Final Exam Review Notes
(
pdf version
)
Last updated:
April 23, 2012
Return to CGS 2545 home page
