PrepZone Logo
PrepZone
Back to Database

Database · Easy

Explain the three-schema architecture and logical vs physical data independence.

DatabaseFundamentalsFresher

Answer preview

The ANSI/SPARC three-schema architecture separates a database into three levels — external (per-user views), conceptual (the whole logical design), and internal (physical storage) — so that changes at one level do not break the level above. That insulation is called data independ…