One of the most important steps in desiging a database is establishing the data model. Part one of a two-part article describes how to create a logical model.

The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to ... Certain data types ...

Logical Schema. A logical data model or logical schema is a representation of the abstract structure of the information domain that defines all the logical constraints applied to the data stored.

However, within the logical data model the goal is to express the business rules and logic. Therefore, abstractions do not have to be avoided, but they should be used surgically. When an area of the ...

For example, a logical model might define what happens with a specific piece of data when specific events or circumstances occur. Physical data models refers to the actual implementation of a ...

Data modeling lives on after the database has been created ... An example of a one-to-one relationship would be ... The logical data model contains more detail than the conceptual data ...

Logical data models detail how entities in the conceptual model map to tables, fields, indexes and relationships within a relational database. For example, a relational table may represent an ...

MISMO, the standards development body for the mortgage industry released its logical data model as the next generation of the MISMO data exchange, according to a press release.The new model has the ...

Logical data model provides underlying structure for communication companies` customer relationship management information needs. By Alison Bull Communications. Johannesburg, 10 May 2001.