1/12

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Sample Schemas

• About the Sample Schemas
• Design Principles of the Sample Schemas
• Customer Benefits of the Sample Schemas
• Overview of the Sample Schemas
  • Schema HR
  • Schema OE
    • OC Description
  • Schema PM
  • Schema IX
  • Schema SH

2 Installing Sample Schemas

• Using the Database Configuration Assistant
• Manually Installing Sample Schemas
  • Schema Dependencies
  • Guidelines for Installing Sample Schemas
  • Installing the HR Schema
  • Installing Schema OE and Subschema OC
  • Installing the PM Schema
  • Installing the IX Schema
  • Installing the SH Schema
• Resetting Sample Schemas
• Uninstalling Sample Schemas

3 Schema Diagrams

• Sample Schema Diagrams

4 Sample Schema Scripts and Object Descriptions

• About the Scripts
• Master Script
  • mksample.sql
• HR Schema
  • HR Table Descriptions
• OE Schema
  • OE Table Descriptions
    • Table OE.CUSTOMERS
    • Table OE.INVENTORIES
    • Table OE.ORDERS
    • Table OE.ORDER_ITEMS
    • Table OE.PRODUCT_DESCRIPTIONS
    • Table OE.PRODUCT_INFORMATION
    • Table OE.WAREHOUSES
    • Table OE.PURCHASEORDER
• PM Schema
  • PM Table Descriptions
• IX Schema
  • IX Table Descriptions
• SH Schema
  • SH Table Descriptions

A Purchase-Order XML Schema

• Purchase-Order XML Schema: File purchaseOrder.xsd

Index