Database Analysis and Design
New Java SQL Processor
SQL Runner readme.txt
ERD - UML Notes
Class Syllabus
Class Syllabus - 2006
Class Project
Initial Enterprise Description
Initial DFD and ERD Diagrams
Formal Database Design
Programming Assignments
Program #1 - Intro to File Structure
Multi-Level Indexing or B-Tree Program
Extendible Hashing Program
Program #3
Program #4 (Final Project)
Homework
Oracle Practice
 
Need Help Running the Java Program?
Handouts
File Structures - Handout I
 
Simple Web App
  (
jar
)
Simple Web App Instructions
Class Notes
Notes on Indexing, Hashing and Extendible Hashing
SQL Notes - part I (click to download Word document - part 1)
SQL Notes - part II (click to download Word document - part 2)
SQL Notes - part III (click to download Word document - part 3)
SQL Notes - part IV [procedures/Functions/Triggers] (click to download Word document - part 4)
SQL Database Creation - part V (click to download zip file - part 5)
Java JDBC Notes Notes (click to download zip file)
Transactions: Recovery and Concurrency Study Notes
Class Resources
2004 Updated Oracle Driver
(classes12.jar)
2000 Updated Oracle Driver
(oracle.zip)
Java JDBC Connection example
Java JDBC GUI Connection example
UML Basics - Handout
Get Your Oracle Account Application Form
The assignment is to familiarize yourself with Java basics - use the web!
Then unzip (use WinZip or Pkzip - available on the Web) the notes and study the JDBC API examples I have provided.
page footer