CS444 Homepage

Database Organization

---

Schedules, Etc.

• Basic Course Information
• Course Schedule
• Text Site
• Oracle On-line Documentation (storage.cs.emporia.edu)
• Chapter Notes

for  files.     . for  files.

---

Programming Assignments

MP1	MP2	MP3	MP4	MP5		mp01.sql	mp02.sql
MP6	MP7	MP8	MP9	MP10		mp05.sql

---

Homework Assignments

Homework Assignments

---

Term Project

• Project Overview
• Project Dates and Deliverables

---

Study Guides

• Exam 1 Study Guide html
• Take Home Final Examination

---

Handouts

• Handout 0 - Accessing Oracle
• Handout 1 - Oracle Dictionary Tables of Interest
• Handout 2 - Relational Operator Summary
• Handout 3 - Simple Queries and SQL for table creation
• Handout 4 - Elements of Oracle SQL
• Handout 5 - Operators, Functions
• Handout 6 - SELECT Statement
• Handout 6a - Oracle Data Dictionary Commands
• Handout 7 - Relational Operator Summary
• Handout 8 - Relational Operators
• Handout 9 - The Daisy Hill Puppy Farm
• Handout 10 - Balanced Trees
• Handout 11 - PL/SQL
• Handout 12 - Hierarchal and Network Databases
• Handout 13 - Functional Dependencies and Normalization
• Handout 14 - Misc. Handouts
• Handout 16 - The Owner/Property Participation Constraint SQL
• Handout 17 - The Roommate problem
• Handout 18 - Specifying Referential Actions for Foreign Keys Example
• Handout 19 - Stored Procedures
• Handout 20 - Partitioning
• Handout 21 - Databases, Clusters, Tablespaces, Packages, Profiles, Users, Instances and Schema

---

Course Related Sites

• Free on-line dictionary of computing
• Some DBMS Resources
• Tutorials Another Tutorial
• Implementing a Database Design in Oracle7
• Intelligent Enterprise
• Oracle FAQ Another FAQ
• SQL Standards Home Page
• www.oracle.com
• CTA program @ Columbia
• Oracle Introduction to SQL Instructions disk 1 disk 2 disk 3

---

On-Line Documentation (mostly Oracle 7)

• SQL*Plus Users Guide and Reference
• SQL*Plus Users Guide and Reference for Windows NT/95
• Personal Oracle Light Programmers Guide
• Replication with Oracle Light
• Oracle SQL Server Reference
• Oracle Data Dictionary
• Some Oracle Admin
• Oracle Client Installation