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.
Define the tables you need based on the information your business requires.