Three-schema architecture (external, conceptual, internal) in DBMS Theory - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the external schema in the three-schema architecture?

The external schema defines how individual users or user groups view the data. It customizes the database view to meet different user needs without changing the actual data.

beginner

Define the conceptual schema in the three-schema architecture.

The conceptual schema represents the overall logical structure of the entire database. It hides physical details and shows what data is stored and the relationships among data.

beginner

What does the internal schema describe in the three-schema architecture?

The internal schema describes how data is physically stored in the database, including file structures, indexes, and storage details.

intermediate

Why is the three-schema architecture important in database management?

It separates user views, logical structure, and physical storage, allowing changes in one layer without affecting others. This improves data independence and flexibility.

beginner

Match the schema to its description: External, Conceptual, Internal.

External schema: User-specific views.<br>Conceptual schema: Overall logical structure.<br>Internal schema: Physical storage details.

Which schema in the three-schema architecture defines the physical storage of data?

A Internal schema

B Conceptual schema

C User schema

D External schema

The internal schema describes how data is physically stored, including files and indexes.

What does the conceptual schema primarily represent?

A Overall logical structure of the database

B User-specific views of data

C Physical storage details

D Backup and recovery procedures

The conceptual schema shows the logical organization of all data and relationships.

Why is the external schema important?

A It manages database security

B It controls physical storage

C It defines the entire database structure

D It provides customized views for different users

The external schema allows different users to see data in ways that suit their needs.

Which of the following is NOT a benefit of the three-schema architecture?

A Data independence

B Direct access to physical storage by users

C Improved user customization

D Flexibility in database design

Users do not access physical storage directly; this is managed by the internal schema.

In the three-schema architecture, changes to the internal schema usually do NOT affect which schema?

A Internal schema

B Conceptual schema

C Both conceptual and external schemas

D External schema

Changes in physical storage (internal schema) do not affect the conceptual or external schemas.

Explain the roles of the external, conceptual, and internal schemas in the three-schema architecture.

Think about who uses each schema and what they see or manage.

Why does the three-schema architecture help in achieving data independence?

Consider how changes in one layer do not force changes in others.