What aspect of database schema defines the logical structure and relationships between tables?

• A. Physical data model
• B. View
• C. Logical data model
• D. Data dictionary

Answer: (C)

The logical data model is a key aspect of database schema that focuses on defining the logical structure and relationships between tables within a database. It lays out how data entities relate to one another, emphasizing the organization of data rather than the physical implementation. This model specifies attributes, data types, and the various relationships—such as one-to-one, one-to-many, and many-to-many—between different tables.

In the context of a database, the logical data model provides an abstract framework that allows for system designers to understand how the data is structured and how it interrelates. This separation of the logical structure from the physical implementation means that the logical model can be refined or adjusted without fundamentally altering how the data is stored or accessed in terms of hardware and physical storage locations.

The physical data model, in contrast, deals with how the data is actually stored in the database, including specifics regarding storage space and access paths, which is not the primary focus when examining the logical structure. A view represents a virtual table derived from one or more tables but doesn’t define the overall structure of data itself. The data dictionary contains metadata about the database elements but does not illustrate how those elements are interconnected.

Thus, the logical data model is the appropriate choice as it effectively