CSCI 275 - Course Notes

Chapter 01 - Jan. 8-11 - Introduction to Databases
Chapter 02 - Jan. 15-18 - Database Environment
Chapter 11 - Jan. 22-24 - E/R Modeling
Chapter 12 - Jan. 24-25 - Enhanced E/R Modeling
Chapter 03 - Jan. 29-Feb 1 - The Relational Model
Chapter 13 - Feb 5-8 - Normalization
Chapter 04 - Feb. 12-15 - Relational Algebra
Chapter 05 - SQL: Data Manipulation
Chapter 06 - SQL: Data Definition
Chapter 20 - Transaction Management

Table Creation syntax

Data Manipulation syntax

SQL Query syntax

SQL*Plus notes

Student Database Files

Embedded SQL in C++ using PRO*C/C++

Embedded SQL in Java using BlueJ