Filter
Top Products
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.
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.
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.