PL/SQL  «Prev  Next»

Lesson 3The course project
ObjectiveExplore to begin solving their Oracle 8i database problem.

Oracle Course Project

House of Pets

Dog from the House of Pets
Dog from the House of Pets

Today you have received an email from the operations manager at House-O-Pets, a Web-based vendor of pet products in San Francisco. House-O-Pets uses Oracle as a back-end database to manage their e-commerce site and keep track of 1) inventory, 2) customers, and 3) customer purchases. They are having a problem with their Oracle database and need your help.
Here is what is going on with the Oracle database:
Our database system has a couple of main problems.

  1. First, the database is not up-to-date with the most current data.
    This provides incorrect data when customers query on products.
  2. Second, the database is plagued with dangling references, which makes data maintenance issues a nightmare.

For confidential information ranging from company history to the database system requirements, review the Fact File that Mr. Schwartz provided to you at the close of your meeting. The information in this folder is essential for solving problems throughout your tenure as DBA for House-O-Pets:
The course project will enable you to demonstrate your knowledge of how to repair or improve the database, through a variety of exercises. You may be asked to analyze and report on existing code, submit pieces of code, or transfer what you have learned to a new situation. Some of the exercises will consist of evaluative simulations where you will be asked to problem-solve within a simulated Oracle environment.
Other exercises require an analysis of the information in the Fact File to solve the problem.
Click the View Fact File Tables link to see the contents of the tables in the House-O-Pets database.
The following contains the Fact File Tables Table
In the exercises, you will:
  1. Query object tables using couple of different techniques
  2. Identify dangling references and update them with a suitable reference
  3. Create SQL commands for updates and deletes so you can update the database with current data

We will provide prompts for you to try exercises on your own if you do have access to Oracle.
You are about to play a major part in administering the House-O-Pets Oracle database.