What is the aim of logical database design?

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

Answer: (C)

Logical database design focuses on defining how data items are identified and related in a way that is independent of how or where they are stored. It sets up a schema with entities, attributes, keys, and constraints so you can locate and retrieve a data item using a logical reference, such as a primary key, while leaving the actual physical storage details to the DBMS. This separation—what data means and how it can be located through logical identifiers—lets users query data without needing to know where or how it’s physically stored. The other ideas touch on how data is related, theoretical rules, or technical storage methods, which are not the central aim of this phase.