What is a Subschema?

What is Subschema with example?

Sub schema It gives the users a window through which he/she can view only that part of the database which he wants. For example − Student table in a database the programmer can access all fields of table, but the user can access only two or three fields of it. Subschema describes both views of the database.

What is a Subschema in computer?

The subschema is the logical description of that section of the database which is relevant and available to an application. A subschema can, of course, be common to two or more different applications.

Where can a Subschema be used?

Explanation. Answer : Hide sensitive information. A subschema lets the user, have access to different areas of applications in which the user designed. The areas that are included in an application are set, types, record types, data items, and data aggregates.

What is instance schema and Subschema in DBMS?

Quickly we can summarize the above things, information/data in database at particular moment is known as instance,physical arrangement of data as it appears in database can be defined as schema, and the logical view of data as it appears to the application can be called as sub schema.