DBA Course Project

The project for this course is a continuation of the one that you have been working on in the previous three courses in the Oracle series. You are a consultant working for Half-Eagle Rarities, an auction house specializing in rare coins from around the world. Half-Eagle Rarities has set up a database to use in running Internet-based coin auctions, and your job is to monitor and manage that database. The logical design of this coin database looks like this:

If you have completed the third course in this series, you should already have a database complete with the tables shown in this design. If you do not have that, you can create the necessary database by following these steps:

1. Go to the Course Resources page.
2. Download either create_coin_80.zip or create_coin_81.zip, depending on whether you are using Oracle8 or Oracle8i.
3. Unzip the file that you downloaded, and follow the instructions in the readme.txt file to create a new database.
4. Go back to the course Resources page and download the two files named coin_schema.sql and gen_coin_data.sql.
5. Create a new user in your database named coin, and grant the CONNECT and RESOURCE roles to thatuser.
6. Using SQL*Plus, connect as the user named coin.
7. Execute the script named coin_schema.sql.
8. Execute the script named gen_coin_data.sql.

In this module, you were introduced to the following glossary terms:

1. SELECT
2. SQL
3. Usenet

Now that you have been introduced to the course objectives and structure, the next module will illustrate proactive methods for monitoring your database.