Three Schema Architecture
Database architecture
Three elements that must be considered when designing a database:
The 3 components mentioned were
- logical schema,
- user view,
- and physical schema.
- The logical schema of a database is its overall logical plan. The logical schema comprises a series of diagrams that define the content of database tables and describe how the tables are linked together for data access.
- Simply stated, a user view determines which users have access to what data in a database.
- The physical schema of a database determines how data is stored on computer hardware (for example, hard drives).
- user views,
- logical schema, or
- physical schema.