Fujitsu UDS/SQL V2.5 Manual Do Utilizador
U929-J-Z125-9-76
43
D
ok
us
c
h
abl
on
en
1
9x
24 V
e
rs
ion
7
.3
us
f
ü
r F
ram
eM
ak
er
V
7
.x
v
o
m
1
4.
02
.2
00
7
©
c
o
gni
tas
Gm
b
H
20
01-
20
07
18
. Ok
tobe
r 20
07
S
ta
nd
1
1:
29
.4
9
P
fa
d:
G
:\
v
og
t\
fs
c
\ud
s
\M
anu
al
e
\e
n\
ud
s
e
nt
_e\
u
ds
ent
.k
0
3
3 Designing the database
In order to design a database with product-specific language resources, it is first necessary
to make a precise and detailed analysis of the data items, their interrelationships, their inter-
dependencies and the specific user requirements. This analysis should be performed as
thoroughly and as carefully as possible because it is of crucial importance for all subse-
quent work. Design errors are known to entail the most far-reaching consequences
because correcting them at a later time involves a lot of effort and expense.
to make a precise and detailed analysis of the data items, their interrelationships, their inter-
dependencies and the specific user requirements. This analysis should be performed as
thoroughly and as carefully as possible because it is of crucial importance for all subse-
quent work. Design errors are known to entail the most far-reaching consequences
because correcting them at a later time involves a lot of effort and expense.
3.1 Data modeling
For data modeling, there are a wide range of models and aids available, the most important
of which include the Entity Relationship Model (ERM) and Structured Analysis (SA).
of which include the Entity Relationship Model (ERM) and Structured Analysis (SA).
For example, a data dictionary can be used to acquire and administer the data collected.
Literature and training programs provide substantially more detailed information on data
analysis and design than can practicably be included in a product-specific manual.
Literature and training programs provide substantially more detailed information on data
analysis and design than can practicably be included in a product-specific manual.
Basically, the analysis includes the following steps:
–
Delimiting the microcosm from the real world
The first step is to define the microcosm, i.e. the section of the real world on which the
data model is to be based, so that the requirements can be implemented in data-
processing procedures.
data model is to be based, so that the requirements can be implemented in data-
processing procedures.
–
Information analysis
The objective of information analysis is to study the data items and information of the
microcosm, as well as the interrelationships of the data items.
microcosm, as well as the interrelationships of the data items.
–
Function analysis
This analysis documents what data is required by the individual applications and in what
order.
order.