1. Database Sample Schemas
  2. Schema Diagrams

3 Schema Diagrams

Examine the diagrams of the sample database schemas.

3.1 Sample Schema Diagrams

Figure 3-1 illustrates sample schemas HR and OE and their relationship. The scripts and table descriptions for these schemas are in section "HR Schema" and "OE Schema", respectively.

Figure 3-2 illustrates schema PM. The scripts and table description for schema PM are at "PM Schema".

Figure 3-3 illustrates schema SH. The scripts and table description for schema SH are in section "SH Schema".

This edition of the book does not illustrate schema IX, but its scripts and table description are in section "IX Schema".

Sample Schema CO illustrates schema CO. The scripts and table description for schema CO are in section "CO Schema"

Figure 3-1 Sample Schemas HR and OE

Description of Figure 3-1 follows
Description of "Figure 3-1 Sample Schemas HR and OE"

Figure 3-2 Sample Schemas OE and PM

Description of Figure 3-2 follows
Description of "Figure 3-2 Sample Schemas OE and PM"

Figure 3-3 Sample Schema SH

Description of Figure 3-3 follows
Description of "Figure 3-3 Sample Schema SH"

Figure 3-4 Sample Schema CO

Description of Figure 3-4 follows
Description of "Figure 3-4 Sample Schema CO"