Progress
Database Design
Guide
Logical Database Design
Logical database design helps you define and communicate your business’ information requirements. When you create a logical database design you describe each piece of information that you need to track and the relationships among, or the business rules that govern, those pieces of information.
Once you create a logical database design, you can verify with users and management that the design is complete (that is, it contains all of the data that must be tracked) and it is accurate (that is, it reflects the correct table relationships and enforces the business rules).
Creating a logical data design is an information-gathering, iterative process. It includes these 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.
- 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 may include all positive numbers.
At this stage, you do not consider processing requirements, performance, or hardware constraints.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |