Database Principles

Tables
This is a list of the tables that are mentioned in class, in the text, or in some of the exercises. Check this list frequently. It will grow as the courses progresses.

Oracle Tables

Note:
Before you can use these tables, you have to have an Oracle user-name and password

ADDRESS

AREAS

COMFORT

INVOICE

LEDGER

LOCATION

LODGING

MY_PAPER01

NAME

NEWSPAPER

PROSPECT

SKILL

STOCK

TWONAME

WEATHER

WORKER

WORKERSKILL

Accessing the Oracle tables
These tables are defined under the user-name zuckerman. In order to access these tables you have to identify them by using the prefix zuckerman, as in,

select feature, page from zuckerman.newspaper ;

Creating your own copies of the Oracle tables
The only operation you can execute on the tables is select. If you want to alter one of the tables you must create your own copy. For example, to create your own copy of the zuckerman.newspaper table you could use the command

create table newspaper as select * from zuckerman.newspaper ;
You can create many copies or versions of a table by asssgning different names to your selections, as in

create table my_paper01 as select * from zuckerman.newspaper ;

Sample databases using Microsoft Access 2000

The following ftp links will allow you to open and save the sample databases wtih Microsoft Access 2000.

CH2_P1

CH3_SALE_CO

CH3_TEXT