Appendix B: The ACME Sample Database

Overview

ACME is the database for a company of the same name that sells some kind of building materials. It has 13 tables described in detail in this chapter.

Note

The database creation scripts on your CD have an additional table, PRODUCT_AUDIT, that is not a part of the ACME business schema but rather is used for auditing. We refer to it in Chapter 14 when discussing triggers.

Preface

Part II: Creating and Modifying Database Objects

Part III: Data Manipulation and Transaction Control

Part V: Implementing Security Using System Catalogs

Part VII: Appendix

Appendix A: What's on the CD-ROM

Appendix B: The ACME Sample Database

General Information and Business Rules

Naming Conventions

Relationships Between Tables

Column Constraints and Defaults

SQL Scripts to Create ACME Database Objects

Appendix C: Basics of Relational Database Design

Appendix D: Installing RDBMS Software

Appendix E: Accessing RDBMS

Appendix F: Installing the ACME Database

Appendix G: SQL Functions

Appendix H: SQL Syntax Reference

Appendix I: SQL-Reserved Keywords

Appendix J: SQL99 Major Features Compliance Across Different RDBMS

Appendix K: The Other RDBMS

Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory

List of Figures

List of Tables

List of Code Examples

List of Sidebars