CGS 2545 - SPRING 2014 - LECTURE NOTES PAGE
INTRODUCTION
Introduction to Database Systems
(
pdf version
)
MODELING DATA IN THE ORGANIZATION (Chapter 2)
Modeling Data In The Organization
(
pdf version
)
THE EER MODEL AND BUSINESS RULES (Chapter 3)
EER Model and Business Rules
(
pdf version
)
LOGICAL DATABASE DESIGN AND THE RELATIONAL MODEL (Chapter 4)
Part 1: Transforming ER Diagrams Into Relational Schemas
(
pdf version
)
Part 2: Normalization
(
pdf version
)
INTRODUCTION TO SQL (Chapter 6)
The Pine Valley Furniture DB from the book (Access Version)
Introduction to SQL
(
pdf version
)
SQL Join Operations
(
pdf version
)
SQL In Class Exercises - Basic SQL
(
pdf version
)
SQL In Class Exercises - SQL Joins and Nested Queries
(
pdf version
)
INTRODUCTION TO MySQL
SQL script for creating the bike database used in many of the MySQL and JDBC Examples
Introduction to MySQL
(
pdf version
)
DATA WAREHOUSING (Chapter 9)
Data Warehousing Concepts - Chapter 9
(
pdf version
)
EXAM #1 - Wednesday February 26th
Exam #1 Review Notes
(
pdf version
)
Exam #1 KEY
(
pdf version
)
FINAL EXAM - Friday April 25th - Starts at 10:00 AM
Final Exam Review Notes
(
pdf version
)
More SQL Query Practice Problems
(
pdf version
)
Solution Key For More SQL Query Practice Problems
(
pdf version
)
Last updated:
April 21, 2014
Return to CGS 2545 home page
