0
0
DBMS Theoryknowledge~10 mins

Three-schema architecture (external, conceptual, internal) in DBMS Theory - Interactive Code Practice

Choose your learning style9 modes available
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the code to name the schema that represents the user's view in the three-schema architecture.

DBMS Theory
The [1] schema defines how individual users see the data.
Drag options to blanks, or click blank then click option'
Ainternal
Bconceptual
Cphysical
Dexternal
Attempts:
3 left
💡 Hint
Common Mistakes
Confusing external schema with internal schema.
Thinking conceptual schema is the user's view.
2fill in blank
medium

Complete the code to identify the schema that describes the overall logical structure of the entire database.

DBMS Theory
The [1] schema defines the logical structure and relationships of all data in the database.
Drag options to blanks, or click blank then click option'
Aconceptual
Binternal
Cphysical
Dexternal
Attempts:
3 left
💡 Hint
Common Mistakes
Mixing up conceptual schema with external schema.
Confusing internal schema with conceptual schema.
3fill in blank
hard

Fix the error in the statement about the internal schema in the three-schema architecture.

DBMS Theory
The [1] schema describes how data is physically stored in the database system.
Drag options to blanks, or click blank then click option'
Ainternal
Bexternal
Cconceptual
Dlogical
Attempts:
3 left
💡 Hint
Common Mistakes
Confusing internal schema with conceptual or external schemas.
Using 'logical' which is not a schema name here.
4fill in blank
hard

Fill both blanks to complete the description of the three-schema architecture layers.

DBMS Theory
The [1] schema shows the physical storage, while the [2] schema shows the user's view.
Drag options to blanks, or click blank then click option'
Ainternal
Bconceptual
Cexternal
Dlogical
Attempts:
3 left
💡 Hint
Common Mistakes
Swapping internal and external schemas.
Using conceptual or logical incorrectly.
5fill in blank
hard

Fill all three blanks to complete the dictionary comprehension representing the three-schema architecture levels.

DBMS Theory
schemas = {"[1]": "User's view", "[2]": "Logical structure", "[3]": "Physical storage"}
Drag options to blanks, or click blank then click option'
Aexternal
Bconceptual
Cinternal
Dphysical
Attempts:
3 left
💡 Hint
Common Mistakes
Using 'physical' as a schema name instead of 'internal'.
Mixing up external and conceptual keys.