Which level of abstraction describes what data are stored in a database?

Concept

Database abstraction separates a database description into levels so that users and programs need not deal with every storage detail.

The physical level addresses storage implementation, the logical level addresses the overall database schema, and the view level addresses user-specific presentations.

Application

The phrase “what data are stored” asks for the overall schema: the entity types, attributes, relationships, and integrity constraints represented in the database. That is the logical level.

Contrast

• Physical level: describes how data are stored through files, indexes, and storage structures.

• View level: describes the selected part of the database visible to a particular user or application.

• Abstraction level: names the general principle of hiding detail, not a separate named level in the standard three-level hierarchy.

Cross-check

A standard summary is: physical means how data are stored; logical means what data are stored and how they relate; view means what a particular user sees. The wording maps to the logical level.

Result

The answer is Logical level.