Notes
Slide Show
Outline
1
 
2
Chapter 12
  • Practice Database Design Methodology and Use of UML Diagrams
3
FIGURE 12.1
Phases of database design and implementation for large databases.
4
FIGURE 12.2
Examples of top-down refinement. (a) Generating a new entity type. (b) Decomposing an entity type into two entity types and a relationship type.
5
FIGURE 12.3
Examples of bottom-up refinement.
(a) Discovering and adding new relationships. (b) Discovering a new category (union type) and relating it.
6
FIGURE 12.4
Modifying views to conform before integration.
7
FIGURE 12.4 (continued)
Modifying views to conform before integration.
8
FIGURE 12.5
Integrated schema after merging views 1 and 2
9
FIGURE 12.6
Different strategies for the view integration process.
10
FIGURE 12.7
The use-case diagram notation.
11
FIGURE 12.8
An example use case diagram for a University Database
12
FIGURE 12.9
The sequence diagram notation.
13
FIGURE 12.10
The statechart diagram notation.
14
FIGURE 12.11
An example statechart diagram for the University Database.
15
FIGURE 12.12
A sequence diagram for the University Database.
16
FIGURE 12.13
A graphical data model diagram in Rational Rose.
17
FIGURE 12.14
A logical data model diagram definition in Rational Rose.
18
FIGURE 12.15
The design of the university database as a class diagram.
19
FIGURE 12.16
The class OM_EMPLOYEE corresponding to the table Employee in Figure 12.14.
20
FIGURE 12.17
The Company Database Class Diagram (Figure 3.16) drawn in Rational Rose.