---
description: Database systems comprise of complex data structures. Thus, to make the system efficient for retrieval of data and reduce the complexity of the users, developers use the method of Data Abstraction. Th
title: DBMS Schemas: Internal, Conceptual, External
image: https://www.guru99.com/images/dbms-schemas-3-level-architecture.png
---

 

[Skip to content](#main) 

**⚡ Smart Summary**

DBMS schemas organize a database into three abstraction levels so users, designers, and administrators each work at the right depth. The internal, conceptual, and external schemas together form the ANSI-SPARC three-level architecture that delivers data independence.

* 🧱 **Core Concept:** Data abstraction hides storage complexity by splitting the database description into three separate schema levels.
* 💾 **Internal Schema:** The lowest level defines physical storage, records, indexes, and access paths on disk.
* 🗂️ **Conceptual Schema:** The single logical level describes all entities, attributes, relationships, and integrity rules for the whole database.
* 👤 **External Schema:** Many user views expose only the data a particular group needs and hide the rest.
* 🔗 **Mappings:** Conceptual-internal and external-conceptual mappings connect the levels and make independence possible.
* 🛡️ **Data Independence:** Storage can change without touching the logical design, and the logical design can grow without breaking existing views.
* 🎯 **Main Goal:** Every user sees a customized view while the administrator freely tunes physical storage underneath.

[ Read More ](javascript:void%280%29;) 

![DBMS Schemas 3-Level Architecture](https://www.guru99.com/images/dbms-schemas-3-level-architecture.png)

## What Is Data Abstraction in DBMS?

Database systems are built on complex data structures. To make the system efficient for data retrieval and to reduce complexity for users, developers use the method of data abstraction. Data abstraction hides the details of how data is stored and maintained, and exposes only what each type of user needs to see.

There are mainly three levels of data abstraction:

1. **Internal Level:** The actual physical storage structure and access paths.
2. **Conceptual or Logical Level:** The structure and constraints for the entire database.
3. **External or View Level:** Describes various user views.

These three levels are described by three corresponding schemas, together known as the ANSI-SPARC three-level architecture. A schema is the design or description of the database at one level; the data itself is called the instance. The diagram below shows how the levels sit above one another.

[![Three level schema architecture in DBMS](https://www.guru99.com/images/1/091318_0814_DBMSSchemas1.png)](https://www.guru99.com/images/1/091318%5F0814%5FDBMSSchemas1.png)

Let us study each level in detail, starting from the storage layer and moving up toward the user.

## Internal Level / Schema

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 multiple occurrences of multiple types of internal record. In ANSI terms, it is also called a “stored record”.

**Facts about internal schema:**

* The internal schema is the lowest level of data abstraction.
* It keeps information about the actual representation of the entire database, such as the actual storage of the data on disk in the form of records.
* The internal view tells us what data is stored in the database and how.
* It never deals with physical devices directly. Instead, the internal schema views a physical device as a collection of physical pages.

Once the storage layer is defined, the logical design that sits above it is described by the conceptual schema.

## Conceptual Schema / Level

The conceptual schema describes the database structure of the whole database for the community of users. This schema hides information about the physical storage structures and focuses on describing data types, entities, relationships, and so on.

This logical level comes between the user level and the physical storage view. There is only a single conceptual view of a single database.

**Facts about conceptual schema:**

* Defines all database entities, their attributes, and their relationships.
* Holds security and integrity information.
* At the conceptual level, the data available to a user must be contained in, or derivable from, the physical level.

The conceptual design is a natural fit for a [relational data model](https://www.guru99.com/relational-data-model-dbms.html), where entities become tables and relationships become keys. Above the conceptual level, individual users see only the slice of data relevant to them, described by the external schema.

## External Schema / Level

An external schema describes the part of the database that a specific user is interested in. It hides the unrelated details of the database from the user. There may be “n” number of external views for each database.

Each external view is defined using an external schema, which consists of definitions of various types of external record for that specific view.

An external view is simply the content of the database as seen by one particular user. For example, a user from the sales department will see only sales related data.

**Facts about external schema:**

* The external level is only related to the data viewed by specific end users.
* This level includes one or more external schemas.
* The external schema level is nearest to the user.
* The external schema describes the segment of the database needed for a certain user group and hides the remaining details from that group.

### RELATED ARTICLES

* [DBMS Keys: Candidate, Primary, Super & Foreign Types ](https://www.guru99.com/dbms-keys.html "DBMS Keys: Candidate, Primary, Super & Foreign Types")
* [Functional Dependency in DBMS: Types with Examples ](https://www.guru99.com/dbms-functional-dependency.html "Functional Dependency in DBMS: Types with Examples")
* [Difference Between Primary key and Unique key ](https://www.guru99.com/difference-between-primary-key-and-unique-key.html "Difference Between Primary key and Unique key")
* [Difference Between Primary Key and Foreign Key ](https://www.guru99.com/difference-between-primary-key-and-foreign-key.html "Difference Between Primary Key and Foreign Key")

## Three-Level Schema Architecture Compared

The three levels are easiest to remember side by side. Each answers a different question, is aimed at a different audience, and changes for different reasons.

| Aspect      | Internal Schema            | Conceptual Schema                 | External Schema        |
| ----------- | -------------------------- | --------------------------------- | ---------------------- |
| Also called | Physical level             | Logical level                     | View level             |
| Describes   | How data is stored on disk | What data and relationships exist | What a user group sees |
| Audience    | Database administrator     | Database designer                 | End user               |
| How many    | One                        | One                               | Many                   |
| Hides       | Nothing below it           | Physical storage                  | Unrelated data         |

The levels do not work in isolation. They are connected by mappings, which are the mechanism that delivers data independence.

## Mappings Between the Schema Levels

A mapping is the correspondence the DBMS keeps between two adjacent levels, so a request at a higher level can be translated into an action at a lower level. The three-level architecture uses two mappings:

* **Conceptual/internal mapping:** connects the logical design to the physical storage. It defines how the entities and attributes in the conceptual schema correspond to the stored records and files in the internal schema. When storage changes, only this mapping is updated.
* **External/conceptual mapping:** connects each user view to the overall logical design. It defines how the fields a user sees relate to the entities in the conceptual schema. When the logical design grows, only the affected mappings are updated.

Because these mappings absorb change, storage can be reorganised without rewriting user programs, which is exactly the [data independence](https://www.guru99.com/dbms-data-independence.html) the architecture is designed to provide.

## Goal of the 3-Level Schema Architecture

Here are some objectives of using the three-schema architecture:

* Every user should be able to access the same data but see a customized view of it.
* The user should not need to deal directly with physical database storage detail.
* The database administrator should be able to change the database storage structure without disturbing users’ views.
* The internal structure of the database should remain unaffected when changes are made to the physical aspects of storage.

## Advantages of a Database Schema

* You can manage data independently of the physical storage.
* Faster migration to new graphical environments.
* The [DBMS architecture](https://www.guru99.com/dbms-architecture.html) lets you make changes at the presentation level without affecting the other two layers.
* Because each tier is separate, it is possible to use different sets of developers.
* It is more secure, as the client does not have direct access to the database business logic.
* If one tier fails, there is no data loss, because you are always secured by accessing the other tier.

## Disadvantages of a Database Schema

* A complete database schema is a complex structure that is difficult for everyone to understand.
* It is difficult to set up and maintain.
* The physical separation of the tiers can affect the performance of the database.

## FAQs

🧱 What is the difference between a schema and an instance?

A schema is the overall design of the database and rarely changes. An instance is the actual data held at a given moment, which changes with every insert, update, or delete.

🗂️ Why is there only one conceptual schema but many external schemas?

The conceptual schema is the single agreed design of the whole database. Each user group needs a different slice of it, so many external schemas are derived from that one conceptual schema.

🛡️ How does the three-level architecture provide data independence?

The two mappings absorb change. A storage change updates only the conceptual-internal mapping, and a logical change updates only the external-conceptual mappings, so higher levels stay intact.

🤖 Can AI generate a database schema from plain requirements?

Yes. AI can turn a written description into an entity relationship draft at the conceptual level, proposing tables, keys, and relationships. A designer should still review normalisation and integrity rules.

👤 Which schema level is closest to the end user?

The external schema, or view level, is closest to the user. It presents only the data a particular group needs and hides both the full logical design and the physical storage beneath it.

#### Summarize this post with:

ChatGPT Perplexity Grok Google AI 

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** 

##### Sign up for the newsletter

Subscribe for Free 

You have successfully subscribed.  
Please check your inbox. 

![AI-Newsletter](https://www.guru99.com/images/footer-email-avatar-imges-1.png) Chosen by over **350,000+** professionals 

[Scroll to top ](#wrapper)Scroll to top 

× 

Toggle Menu Close 

Search for: 

Search

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/dbms-schemas-3-level-architecture.png","url":"https://www.guru99.com/images/dbms-schemas-3-level-architecture.png","width":"700","height":"250","caption":"DBMS Schemas - 3-Level Architecture","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/dbms-schemas.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/dbms","name":"DBMS"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/dbms-schemas.html","name":"DBMS Schemas: Internal, Conceptual, External"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/dbms-schemas.html#webpage","url":"https://www.guru99.com/dbms-schemas.html","name":"DBMS Schemas: Internal, Conceptual, External","dateModified":"2026-07-22T12:35:46+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/dbms-schemas-3-level-architecture.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/dbms-schemas.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/fiona","name":"Fiona Brown","description":"I'm Fiona brown, a Full Stack Developer with over a decade of experience, sharing practical guides on robust and scalable application development.","url":"https://www.guru99.com/author/fiona","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/fiona-brown-author.png","url":"https://www.guru99.com/images/fiona-brown-author.png","caption":"Fiona Brown","inLanguage":"en-US"},"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"DBMS","headline":"DBMS Schemas: Internal, Conceptual, External","description":"Database systems comprise of complex data structures. Thus, to make the system efficient for retrieval of data and reduce the complexity of the users, developers use the method of Data Abstraction. Th","keywords":"dbms, sql","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/fiona","name":"Fiona Brown"},"dateModified":"2026-07-22T12:35:46+05:30","image":{"@id":"https://www.guru99.com/images/dbms-schemas-3-level-architecture.png"},"copyrightYear":"2026","name":"DBMS Schemas: Internal, Conceptual, External","subjectOf":[{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is the difference between a schema and an instance?","acceptedAnswer":{"@type":"Answer","text":"A schema is the overall design of the database and rarely changes. An instance is the actual data held at a given moment, which changes with every insert, update, or delete."}},{"@type":"Question","name":"Why is there only one conceptual schema but many external schemas?","acceptedAnswer":{"@type":"Answer","text":"The conceptual schema is the single agreed design of the whole database. Each user group needs a different slice of it, so many external schemas are derived from that one conceptual schema."}},{"@type":"Question","name":"How does the three-level architecture provide data independence?","acceptedAnswer":{"@type":"Answer","text":"The two mappings absorb change. A storage change updates only the conceptual-internal mapping, and a logical change updates only the external-conceptual mappings, so higher levels stay intact."}},{"@type":"Question","name":"Can AI generate a database schema from plain requirements?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI can turn a written description into an entity relationship draft at the conceptual level, proposing tables, keys, and relationships. A designer should still review normalisation and integrity rules."}},{"@type":"Question","name":"Which schema level is closest to the end user?","acceptedAnswer":{"@type":"Answer","text":"The external schema, or view level, is closest to the user. It presents only the data a particular group needs and hides both the full logical design and the physical storage beneath it."}}]}],"@id":"https://www.guru99.com/dbms-schemas.html#schema-1148130","isPartOf":{"@id":"https://www.guru99.com/dbms-schemas.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/dbms-schemas.html#webpage"}}]}
```