Three-tier structure of DBMS in ANSI-SPARC, extended SPARC is _________
2016
Three-tier structure of DBMS in ANSI-SPARC, extended SPARC is _________
- A.
System planning and requirement committee
- B.
Standard planning and requirement committee
- C.
System planning and Reassesment committee
- D.
System planning and review committee
Attempted by 397 students.
Show answer & explanation
Correct answer: B
The correct option is B (Standard planning and requirement committee).
The question asks for the expansion of SPARC within the context of the ANSI-SPARC architecture, which defines the classic three-tier (three-schema) structure of a Database Management System (DBMS).
Full Form: ANSI stands for American National Standards Institute, and SPARC stands for Standards Planning And Requirements Committee.
Historical Context: In 1975, the ANSI/X3/SPARC study group proposed a framework for database management systems to achieve data independence.
Three-Tier Architecture: This framework divides a database system into three abstraction levels to separate the user applications from the physical database:
External Level (View Schema): What the individual users see.
Conceptual Level (Logical Schema): The community view of the entire data structure, detailing what data is stored and their relationships.
Internal Level (Physical Schema): How the data is physically stored on the storage disk.