DBMS Data Description Levels

Let's take an ABC company with four departments:

  1. Purchasing

  2. Sales

  3. Finance

  4. 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:

  1. Conceptual level

  2. External level

  3. Internal level

Data Independence in DBMS

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.