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.

Logical and Physical Database Requirements. The requirements for a logical and physical database vary by size and design parameters. A logical database must be able to access and identify all ...

Under usual circumstances, the one-to-many or many-to-many relationship, alone, drives the pattern used within the database model. Certainly, the logical database model should represent the proper ...

When building up a logical design, primary keys should be identified by the actual data points in play. Generated or surrogate keys should be held in abeyance until dealing with the physical design ...