Sub-Schema

Subschema — The Customized View

A subschema is a subset of the database schema — designed for a particular application, user, or role.

Like giving an intern a limited blueprint — only the rooms they’re allowed to access.

Example:

• An HR app may only need access to Users and Salaries tables.

• A subschema can hide the rest of the database structure.

💡 Characteristics:

• Controls what part of the schema is visible

• Ensures data abstraction and security

• Often implemented using views or access permissions