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