CS545 Homepage

Database Theory

---

Schedules, Etc.

• Basic Course Information
• Course Schedule
• Course Homepage Requirement
• Text Site
• Academic Web Site

for  files.     . for  files.

---

Programming Assignments

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

---

Homework Assignments

HW1	HW2	HW3	HW4	HW5
HW6	HW7	HW8	HW9	HW10

---

Term Project

• Project Overview
• Project Dates and Deliverables

---

Study Guides

• Exam 1 Study Guide
• Final Examination Study Guide

---

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 7 - Relational Operator Summary
• Handout 8 - Relational Operators
• Handout 9 - Elmasri/Navathe Chapter 7 Notes
• Handout 10 - Elmasri/Navathe Chapter 12 Notes
• Handout 11 - The Daisy Hill Puppy Farm
• Handout 12 - Balanced Trees
• Handout 13 - Elmasri/Navathe Chapter 8 Notes
• Handout 14 - PL/SQL
• Handout 15 - Hierarchal and Network Databases

---

Course Related Sites

• Free on-line dictionary of computing
• Some DBMS Resources
• Tutorials
• Implementing a Database Design in Oracle7
• Intelligent Enterprise
• Oracle FAQ
• SQL Standards Home Page
• www.oracle.com
• CTA program @ Columbia

---

On-Line Documentation

• 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
• Documentation Library Home Page for Oracle8 Enterprise Edition release 8.0.4
• Oracle8 Administrator's Reference for Sun SPARC Solaris 2.x
• Oracle Data Dictionary
• Some Oracle Admin