Which part of the three-schema approach describes the stored representation of enterprise information?

Which part of the three-schema approach describes the stored representation of enterprise information?

• A. Conceptual schema
• B. Internal schema
• C. External schema
• D. Logical schema

Answer: (B)

The internal schema is the correct answer because it specifically refers to the physical storage structure of the database. In the three-schema architecture, which includes the internal, conceptual, and external schemas, the internal schema serves to define how data is stored in the system, including data structures, file formats, and access methods. This schema abstracts the hardware aspects and focuses on how the data is organized on storage media, such as disks. It deals with the complexities of the actual data storage details, allowing the other schemas (conceptual and external) to remain unaffected by changes in storage technology or methods. The conceptual schema, on the other hand, describes the logical structure of the entire database from a user perspective, including the relationships between data entities and the rules governing them. The external schema defines how individual users perceive the data, often through different views, which are tailored to specific user requirements. The logical schema can be seen as a bridge between the conceptual and internal schemas, outlining the logical structure without concern for how it is physically implemented. In essence, the internal schema is key to understanding how enterprise information is stored, making it the correct choice in this context.

The internal schema is the correct answer because it specifically refers to the physical storage structure of the database. In the three-schema architecture, which includes the internal, conceptual, and external schemas, the internal schema serves to define how data is stored in the system, including data structures, file formats, and access methods.

This schema abstracts the hardware aspects and focuses on how the data is organized on storage media, such as disks. It deals with the complexities of the actual data storage details, allowing the other schemas (conceptual and external) to remain unaffected by changes in storage technology or methods.

The conceptual schema, on the other hand, describes the logical structure of the entire database from a user perspective, including the relationships between data entities and the rules governing them. The external schema defines how individual users perceive the data, often through different views, which are tailored to specific user requirements. The logical schema can be seen as a bridge between the conceptual and internal schemas, outlining the logical structure without concern for how it is physically implemented.

In essence, the internal schema is key to understanding how enterprise information is stored, making it the correct choice in this context.