RelationalDBDesign 





Managing Users  «Prev  Next»
Lesson 2 Oracle course database
ObjectiveUnderstand the design for the course project.

Managing Course Database

Throughout the course, you will be working on a course project database you will create and maintain.
This will give you the opportunity to apply the skills you are learning to the real world.
For your project, you are a consultant working for Half-Eagle Rarities, an auction house specializing in rare coins from around the world. Like everyone else, Half-Eagle Rarities wants to get on the internet, and carve out a niche in the world of online commerce. Your client has just purchased a software package designed to manage coin auctions over the internet using a web-based interface. Your mission is to set up and create the database to support that software. The logical design already exists, and looks like this:


Half-Eagle Rarities database consists of LOT, COINS_IN_LOT, COIN, AUCTION, BID, CLIENT
Half-Eagle Rarities database consists of LOT, COINS_IN_LOT, COIN, AUCTION, BID, CLIENT

In part 1 of this series, you created a bare-bones database. As yet, it doesn't have any of the tables referenced in the logical design.
In this course, you will create some users and some user profiles for the coin database. In part 3, you will create the actual tables.
If you do not have the database that you created in part 1, you can download the scripts to create the coin database from the course resource page. You can download a compressed file that contains two versions of the coin database creation script. One will run under a standard 8i install, the other under an 8.0 install. If you are running Oracle, download whichever script corresponds to your install. One of the resulting files will be named readme.txt. Using the supplied scripts, you can follow the instructions in the readme file to create a database that you can use for this course.
If you already have access to an Oracle database, you can use it for this course even though it does not exactly match that created in part 1.
You may have to make minor adjustments to tablespace names in some of the examples.