CGS 2545 - Summer 2007 - 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: In-class Exercises
(
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 (Examples)
(
pdf version
)
CHAPTER 9 - THE CLIENT/SERVER DATABASE ENVIRONMENT
Chapter 9: The Client/Server Database Environment
(
pdf version
)
CHAPTER 13 - DISTRIBUTED DATABASE SYSTEMS
Chapter 13: Distributed Database Systems
(
pdf version
)
EXAM #1 - Tuesday June 19th
Exam #1 Review Notes
(
pdf version
)
Exam #1 KEY
(
pdf version
)
EXAM #1 - Thursday July 12th
Exam #2 Review Notes
(
pdf version
)
Exam #2 KEY
(
pdf version
)
Exam #2 Part 2KEY
(
pdf version
)
FINAL EXAM - Thursday August 2nd - regular class time - regular room
Final Exam Review Notes
(
pdf version
)
Last updated:
July 30, 2007
Return to CGS 2545 home page
