The aim of a logical database design is:

• A. The application of Codd's Law to every table
• B. To provide a logical reference to a given data item to locate it within the physical database
• C. The representation of the relationship existing between two data items
• D. To apply a hashing function to the key to obtain an address

Answer: (A)

Logical database design aims to model data and its interrelationships in a way that supports accurate querying and data integrity, independent of how data is stored. The focus is on organizing information into well-defined structures (entities and their attributes) and capturing how those pieces relate to one another, so you can enforce data dependencies and minimize redundancy through normalization. For example, modeling a student–course relationship with a enrollment construct shows how entities connect, and using primary and foreign keys enforces the valid links between them.

This approach is not about applying Codd's laws to each table, which describes overall relational system characteristics rather than a specific design action. It’s also not about locating data items in the physical storage or using hashing to compute addresses, which belong to physical design and indexing decisions rather than the logical data model.