Data modeling Database de sign
44 U929-J-Z125-9-76
The analytical process yields a model which describe s 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 relation ships existing
between the data items is defined, e.g. a 1:n relationship between c ustomer and order.
The logical structure of the data is also called the conceptional schema. Th e conceptional
schema is an important basis for further work , both for database designers and for
specialized departments. The conceptional schema repres ents 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 necessar y to consider how the data
is to be distributed in databases and on different systems.