What is the difference between schema and Subschema?

What is a schema Subschema?

A sub-schema is a subset of the schema having the same properties that a schema has. It identifies a subset of areas, sets, records and data names defined in the database schema available to user sessions. The sub-schema allows the user to view only that part of the database that is of interest to him.

What is Subschema and its 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 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.

What is the difference between schema and DB?

A database is the main container, it contains the data and log files, and all the schemas within it. You always back up a database, it is a discrete unit on its own. Schemas are like folders within a database, and are mainly used to group logical objects together, which leads to ease of setting permissions by schema.