Fujitsu UDS/SQL V2.5 用户手册
Data modeling
Database design
44
U929-J-Z125-9-76
The analytical process yields a model which describes the designated section of the real
world in such a way that the data can be administered with a database system. The data is
complete, consistent and available in normalized form. The type of relationships existing
between the data items is defined, e.g. a 1:n relationship between customer and order.
world in such a way that the data can be administered with a database system. The data is
complete, consistent and available in normalized form. The type of relationships existing
between the data items is defined, e.g. a 1:n relationship between customer and order.
The logical structure of the data is also called the conceptional schema. The conceptional
schema is an important basis for further work, both for database designers and for
specialized departments. The conceptional schema represents the data items and their
interrelationships without defining the data model in which the described structure is
mapped.
schema is an important basis for further work, both for database designers and for
specialized departments. The conceptional schema represents the data items and their
interrelationships without defining the data model in which the described structure is
mapped.
After a conceptional schema has been developed, it is necessary to consider how the data
is to be distributed in databases and on different systems.
is to be distributed in databases and on different systems.