Normalised Relational Database Design
Data Perception Consulting have undertaken Microsoft Access database development since 1992, delivering solid commercial applications to UK business, and the world via the Internet.
Normalised relational design need not be complex. The demands of the application, the requirement, dictate the complexity and number of tables and relationships.
Examples one (opens in new window) and two (opens in new window) illustrate more complex relational schema, perhaps more typical of business applications.
The final design illustrates a powerful corporate database where integrity, strict field control, user restriction and security are mandatory three (large - 55kb) (opens in new window).