DATABASE FUNDAMENTALS
DATABASE CONCEPTS AND STRUCTURES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
External schemas
|
|
|
Internal schema
|
|
|
Schema Construct
|
|
|
Conceptual schema
|
Detailed explanation-1: -The three schema architecture is also called ANSI/SPARC architecture or three-level architecture. This framework is used to describe the structure of a specific database system. The three schema architecture is also used to separate the user applications and physical database.
Detailed explanation-2: -What Does Three-Schema Architecture Mean? Three-schema architecture is an idea in relational database design that breaks a database down into three different categories according to its use and structure, and to the roles played by system administrators, designers and end users.
Detailed explanation-3: -A conceptual schema is a high-level description of informational needs underlying the design of a database. It typically includes only the main concepts and the main relationships among them. Typically this is a first-cut model, with insufficient detail to build an actual database.