Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

About the Sample Schemas

Customer Benefits of the Sample Schemas

Oracle Database Sample Schemas Design Principles

Organization

Related Documentation

Conventions

Documentation Accessibility

1 Installation

Using the Database Configuration Assistant

Manually Installing the Sample Schemas

Schema Dependencies

Installing the Human Resources (HR) Schema

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

Installing the Product Media (PM) Schema

Installing the Information Exchange (IX) Schema

Installing the Sales History (SH) Schema

Resetting the Sample Schemas

2 Rationale

Overall Description

Human Resources (HR)

Order Entry (OE)

Product Media (PM)

Information Exchange (IX)

Sales History (SH)

3 Diagrams

Sample Schema Diagrams

4 Sample Schema Scripts and Object Descriptions

About the Scripts

Master Script

mksample.sql

HR Schema

OE Schema

PM Schema

IX Schema

SH Schema

Index