Program 2
CS 450
In this assignment, you are to experiment with using Oracle Database. Your job will be to create a simple two or three Table Database with relations connecting the tables. Each table should have a minimum of 20 records. The tables should have primary keys, and at least one foreign key. Some fields should have value constraints, and some should be tagged NOT NULL.
Your assignment is to demonstrate the following:
1. Three Simple queries - one per each table
2. Two Queries with a single join, use GROUP BY, ORDER BY
3. One Query with a three-way join
4. Two reports with headings, computed fields, breaks
5. Two scalar functions
6. One View on Two Tables
7. One View on a Single Table (which can be updated - show the update)
8. One procedure with an anonymous block (PL/SQL)
9. One sequence
10. One stored scalar function (PL/SQL)
All your projects should be well documented and organized to clearly show that you have successfully satisfied the requirements. Each group member should be a part of at least 3 of the above activites described above. Each group member may also submit an additional individual piece. This peice MUST relate to the database project above. It should be something above and beyond what has been required.
NOTE: Be sure that your project is clearly presented, and that includes a formal table of contents (TOC) with paging to allow easy location of sections.
Due: November 15th, 1999
The Libray has reference materials available. Please visit the Library and make use of them. They are listed under CS450.