CS444 Homepage

Database Organization

---

Schedules, Etc.

• Basic Course Information
• Course Schedule
• Text Site
• Oracle On-line Documentation
• Chapter Notes
• Installing the Oracle Client

for  files.     . for  files.

---

Programming Assignments

MP1	MP2	MP3	MP4	MP5		mp01.sql	mp02.sql
MP6	MP7	MP8	MP9	MP10		mp05.sql
MP11	MP12	MP12 addendum	MP13	MP14

---

Homework Assignments

Homework Assignments

HW7

4.8 and 4.12 RA word doc

---

Term Project

• Project Overview
• Some Suggested Projects
• Project Dates and Deliverables

---

Study Guides

• Exam 1 Study Guide
• Final Exam

---

Handouts

• Handout 0 - Accessing Oracle
• Handout 1a - Oracle Dictionary Tables of Interest Complete Data Dictionary Description
• Handout 1b - Useful Oracle Commands
• Handout 1c - SQL*Plus Quick Reference
• 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 8a - Grouping and like matters
• Handout 8b - Constraints & Triggers
• Handout 8c - Relational Algebra Symbols and Examples
• Handout 8d - Row Identification and Related Matters
• Handout 9 - The Daisy Hill Puppy Farm
• Handout 10 - Balanced Trees another B-tree description
• 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
• Handout 22 - Implementing Constraints in Oracle
• Handout 23 - Oracle PRO*C
• Handout 24 - ADODC Example
• Handout 25 - ADO Examples
• Handout 26 - Visual C MFC ODBC Examples
• Handout 27 - The Kramer Handout code
• Handout 28 - DTL

---

Course Related Sites

• Free on-line dictionary of computing
• Some DBMS Resources
• Tutorials Another Tutorial Yet another tutorial Another
• Intelligent Enterprise
• Oracle FAQ
• Another Oracle FAQ
• SQL Standards Home Page
• www.oracle.com
• sqlcourse2.com
• Oracle Introduction to SQL Instructions disk 1 disk 2 disk 3
• Visual Basic and Databases
• Server 2000 Documentation
• HOW TO DRAW UML DIAGRAMS

---

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
• Integrating Pro*C/C++ into Microsoft Visual C++
• Oracle Data Dictionary
• Some Oracle Admin more admin
• Oracle Client Installation (8i)
• OTN
  • http://otn.oracle.com/software/content.html
    http://tahiti.oracle.com/
    http://oracle.com/education/oln/