Describe the three schema architecture why do we need mappings between schema levels
Answers
Answered by
1
hey mate.
The goal of he three-schema architecture is to separate the user applications and the physical database. In this architecture schemas can be defined at the following three levels.
(1) internal level :-
it has an internal schema, which describes the physical storage structure of the database.
(2) Conceptual level :-
It has a conceptual schema, which describes the structure of the whole database for a community of users. The conceptual schema hides the details of physical storage structures and concentrates on describing entities, data types, relationships, user operations and constraints.
please mark the brainlist answer
The goal of he three-schema architecture is to separate the user applications and the physical database. In this architecture schemas can be defined at the following three levels.
(1) internal level :-
it has an internal schema, which describes the physical storage structure of the database.
(2) Conceptual level :-
It has a conceptual schema, which describes the structure of the whole database for a community of users. The conceptual schema hides the details of physical storage structures and concentrates on describing entities, data types, relationships, user operations and constraints.
please mark the brainlist answer
Answered by
2
Explanation:
The mapping also helps in different kinds of transformation. A DBMS (database management system) has three schema levels as given below: Physical or internal schema – Helps to define how data is stored in the computer. ... External or view level schema – Define the various views and data representations
Similar questions