Conceptual level, internal level and External level are three components of the three-level RDBMS architecture. which of the following is not of the conceptual level?
Conceptual level, internal level and External level are three components of the three-level RDBMS architecture. which of the following is not of the conceptual level? Correct Answer Storage dependent details
Concept:
Three level architecture is a framework for describing database concepts and specifying the structure of the database system. Three levels are the external level, conceptual level, and internal level.
Explanation:
Internal level:
It describes the actual physical storage of data or the way in which the data is actually stored in memory. It is not relational because data is stored according to various coding schemes instead of tabular form.
Conceptual level:
It is also known as a logical level. It is relational because data visible at will be relational tables. It represents the entire contents of the database in an abstract form. It hides the actual physical storage and concentrates on the relational model of the database.
External level:
It is concerned with individual users. It describes the actual view of data seen by individual users. It is defined by DBA for every user. Users can only access data for which he is authorized by DBA.