- It is an individual user's partial view of the database.
- Sub-schema provides different view of the data to the users and the programmers, who do not need to know all the data contained in the entire database.
- Sub-schema enhances security factors and prohibit data compromise.
- Sub-schema aid DBA while assuring data integrity.