DBMS Data Description Levels
Let's take an ABC company with four departments:
Purchasing
Sales
Finance
HR
All these employees, in their daily tasks, use and manipulate data stored in a database on the company's servers, using a DBMS.
This database contains data from all 4 departments.
An important point is that each employee should only have access to the data he or she is concerned with. For example, an HR department manager should only have access to HR data, and should not, for example, have access to Finance department data. The same applies to a person who should only have access to finance data, and should not have access to HR data.
This means that each user should only have access to part of the data, and should only view the tables relevant to his or her function. This corresponds to the external data level.
There are commonly three (3) levels of DB description in a DBMS:
Conceptual level
External level
Internal level

External diagram
Describes how a user or program perceives the data to which it has access.
→View: subset of a DB
View1: HR data
View2: financial data
Conceptual diagram
Describe, in a formal and easily understandable way, the company's data that will be used by its IS.
There are four main classes of data model, distinguished by the nature of the associations they model. These are :
Hierarchical models
Network models
Relational models
Object models
→The conceptual diagram describes :
Real-world objects.
Properties of real-world objects
Links between objects
Internal diagram
The internal schema defines the physical storage structure of the database. The internal schema is a very low-level representation of the entire database. It contains several occurrences of various internal record types.
Describe the data as it is stored in the machine.
The storage space reserved for each item of information
Files containing data and their location
Representation of data in bits.