Database Design: Know It All

List of Figures

Figure 1.1. The database life cycle.

Figure 1.2. Life cycle results, step-by-step.

Figure 1.3. A simple form of ER model using the Chen notation.

FIGURE 2.1. SQL declaration of customers table with primary key cid and candidate key ssn.

FIGURE 2.2. Example of ER diagrams with entities and attributes.

FIGURE 2.3. Examples of ER diagrams with relationships.

FIGURE 2.4. A table representing an entity, Employees, and a ring (recursive relationship), manages.

FIGURE 2.5. Basic ER concepts: (a) entities and attributes, and (b) relationships.

FIGURE 2.6. Examples of relationships R between two entities E and F.

FIGURE 2.7. An ER diagram with labels (x, y) on ER connections.

FIGURE 2.8. Relational design for Employees works_on Projects ...