Relationships Between Tables

Relationships Between Tables

Tables in ACME are connected by primary/foreign key relationships (as in any relational database). The database is normalized to a certain degree (see Appendix C for relational database design basics and Normalization rules). Figure B-1 shows ACME tables and relationships between them.

Click To expand

Figure B-1: ACME database schema

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 Code Examples

List of Sidebars