Announcements from the Instructor

Csci 5705, Object Oriented Database, Winter 1999.

OGIS link: SQL92/OGIS

Oracle 8 Notes for HW 3: A set of examples and notes on topics ranging from "Getting started with Oracle" to object relational features is available on-line from this link . It includes notes on PL/SQL as well as comparison of Oracle SQL with SQL2 standard. Full documentaion for Oracle8 , provides details of VARRAYs in chapter 4 etc.

Lecture Notes: The lecture notes for Ullman's book is available from the web-site for the book. We will use the slides from Ullman's offering.

Homework 0 on Pre-requisite Courses:

1. There will be a home work 0 on the pre-requisite knowledge. The pre-requisite courses include Csci 5705 (Database I) and Csci 3321 (C++ and Data-Structures). Relevant topics from Csci 5705 include conceptual data model (e.g. entity relationship), relational data model, normal forms (1-3), relational algebra, basic SQL (select, project, join, nested query using "exists", aggregate query) and integrity constraints. Relevant topics from Csci 3321 include the basic object model (e.g. object, class, inheritance, polymorphism, instance/class variables/methods), and its implementation in a programming language (e.g. C++).
2. Sample Exams. from Csci 5702 ( postscript , pdf ) and 3321 ( postscript , pdf ). Homework 0 refers to the questions from these exams.