Try OpenEdge Now
skip to main content
Guide for New Developers
Configuring OpenEdge : Understanding the RDBMS architecture : Logical Database

Logical Database

A Logical database helps you define and communicate your business’ information requirements. Creating a logical data design is an information-gathering, iterative process. It includes the following steps:
*Define the tables you need based on the information your business requires.
*Determine the relationships between the tables.
*Determine the contents (or columns) of each table.
*Normalize the tables to at least the third normal form. To understand more about normal forms, refer the topics on Normalization in the OpenEdge Getting Started: Database Essentials guide.
*Determine the primary keys and the column domain. A domain is the set of valid values for each column. For example, the domain for the customer number can include all positive numbers.