Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Name the three levels of the three-schema architecture and what each one describes.
- Explain logical data independence with a concrete example.
- Explain physical data independence with a concrete example.
- Say which level a given change (a new index, a renamed column, a new view) actually affects.
A DBMS was introduced earlier as something that keeps an application's code working even when storage changes underneath it. This page names the three levels that make that promise concrete, so later talk of "logical" versus "physical" changes has a fixed meaning.