Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

About the Sa mple Schemas

Customer Benefits of the Sample Schemas

Oracle Database Sample Schemas Design Principles

Organization

Related Documentation

Conventions

Documentation Accessibility

1 Installation

Using the Database Confi guration Assistant

Manually Installing the Sample Schemas

Schema Dependencies

Installing the Human R esources (HR) Schema

Installing the Order Entry (OE) Schema and its Online Catalo g (OC) Subschema

Installing the Product Media (PM) Schema

Installing the Information Exchange (IX) Schema

Inst alling the Sales History (SH) Schema

Resetting the Sample Schemas

2 Rationale

Overall Description

Human Resou rces (HR)

Order Entry (OE)

Product Media (PM)

Information Exchange (IX)

Sales History (SH)

3 Diagrams

Sample Schema Diagrams

4 Sample Schema Scripts and Object Descriptio ns

About the Scripts

Master Script

mksample.sql

HR Schema

OE Schema

PM Schema

IX Schema

SH Schema

Index