CSE Roadmap

Common tier · about 2 hours · 5 parts

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.