Design methodology
|
A
structured approach that uses Procedures,
Techniques, Tools, and documentation aids
to support and facilitate the process of
design Consists of phases that contain
steps, which guided the designer in the
techniques, to plan, manage, control, and
evaluate database development projects. |
Memo
and
Comment
|
| Phases of
Database Design |
- Phase
1: Conceptual Database Design
- Phase
2: Logical Database Design
- Phase
3 : Physical Database Design
|
Phase 1
Conceptual |
- To
build the conceptual
representation of the
database
- To
identify the important entity and
relationship types
- Construct
a model of information that used
in an enterprise
- Begin
with the creation of a conceptual
data model
- Independent
of implementation details of any
physical considerations
|
Phase 2
Logical |
- To
translate to the conceptual
representation to logical
structure of the database
- To
design the relations
- Construct
a model of information that used
in an enterprise based on a
specific data model
- Map
the conceptual data model,
which is influenced by the target
data model for database
- Source
of implementation for the
physical design phase
|
Phase 3
Physical |
- To
allow the designer to decide how
the logical structure to be
physically implemented as the
tables on the target database
management system.
- Describe
the storage structures and access
method used to achieve efficient
to the data from a database.
- Allows
the designer to make decision on
how the database is to be
implemented
- Tailored
to the specific DBMS systems
- May
effect the structure of logical
data model if there are needs to
improving the performance of the
systems.
|