CGS 2545 - FALL 2011 - 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
)
ADVANCED SQL (Chapter 7)
Advanced SQL
(
pdf version
)
SQL In Class Exercises
(
pdf version
)
THE PHYSICAL DATABASE (Chapter 5)
Physical Database Design Considerations
(
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
)
DATA WAREHOUSING (Chapter 9)
Data Warehousing Concepts - Chapter 9
(
pdf version
)
EXAM #1 - Wednesday September 28th
Exam #1 Review Notes
(
pdf version
)
Exam #1 KEY
(
pdf version
)
EXAM #2 - Wednesday November 2nd
Exam #2 Review Notes
(
pdf version
)
Exam #2 KEY
(
pdf version
)
FINAL EXAM - Monday December 5th - Starts at 1:00 PM
Final Exam Review Notes
(
pdf version
)
Last updated:
November 30, 2011
Return to CGS 2545 home page
