CGS 2545 - FALL 2010 - LECTURE NOTES PAGE
CHAPTER 1 - INTRODUCTION
Introduction to Database Systems
(
pdf version
)
CHAPTER 2 - THE DATABASE DEVELOPMENT PROCESS
Chapter 2: The Database Development Process
(
pdf version
)
CHAPTER 3 - MODELING DATA IN THE ORGANIZATION
Chapter 3: Modeling Data In The Organization
(
pdf version
)
Chapter 3: In-class Exercises
(
pdf version )
CHAPTER 4 - THE EER MODEL AND BUSINESS RULES
Chapter 4: EER Model and More on Business Rules
(
pdf version
)
Chapter 4: In-class Exercises
(
pdf version )
CHAPTER 5 - LOGICAL DATABASE DESIGN AND THE RELATIONAL MODEL
Chapter 5 - Part 1: Transforming ER Diagrams Into Relational Schemas
(
pdf version
)
Chapter 5 - Part 2: Normalization
(
pdf version
)
CHAPTER 7 - INTRODUCTION TO SQL
Chapter 7: Introduction to SQL
(
pdf version
)
CHAPTER 8 - ADVANCED SQL
Chapter 8: Advanced SQL
(
pdf version
)
SQL In Class Exercises
(
pdf version
)
CHAPTER 6 - THE PHYSICAL DATABASE
Chapter 6: Physical Database Design Considerations
(
pdf version
)
CHAPTER 12 - DATA AND DATABASE ADMINISTRATION
Chapter 12: Data and Database Administration
(
pdf version
)
DISTRIBUTED DATABASE SYSTEMS
Distributed Database Management Systems
(
pdf version
)
CHAPTER 11 - DATA WAREHOUSING
Chapter 11: Data Warehousing Concepts
(
pdf version
)
EXAM #1 - Monday September 27th
Exam #1 Review Notes
(
pdf version
)
Exam #1 KEY
(
pdf version
)
EXAM #2 - Friday November 5th
Exam #2 Review Notes
(
pdf version
)
Exam #2 KEY
(
pdf version
)
FINAL EXAM - Monday December 13th - Starts at 1:00 PM
Final Exam Review Notes
(
pdf version
)
Last updated:
December 6, 2010
Return to CGS 2545 home page
