answersLogoWhite

0


Best Answer

The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Kiranjeet Kaur

Lvl 2
4y ago

difference between schema and subschema

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Schema

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is schema and sub-schema?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why should a subschema be independent of schema?

A subschema should be independent of the schema to ensure modularity and reusability. This allows the subschema to be easily used in different contexts without being tightly coupled to any specific schema, providing flexibility and promoting code maintainability.


Why subschema is independent of schema?

A subschema is a subset of a larger schema, and it is designed to be independent and self-contained. It can exist and operate separately from the larger schema, providing specific functionality or representing a specific component of the overall schema. This independence allows for modular design and development, making it easier to manage and maintain the schema as a whole.


What is difference between Schema and Subschema?

SCHEMA is the physical arrangement of the data as it appears in the DBMS. SUB-SCHEMA is the logical view of the data as it appears to the application program.


Description of database subschema?

What are the purpose of developing a sub-schema in database? In database management, the Subschema pronounced "sub-skee-mah." is an individual user's partial view of the database while the schema is the entire database. It is the applications programmer's view of the data within the database pertinent to the specific application. A subschema has access to those areas, set types, record types, data items, and data aggregates of interest in the pertinent application to which it was designed. Naturally, a software system usually has more than one programmer assigned and includes more than one application. This means there are usually many different sub schemas for each schema. The following are a few of the many reasons sub schemas are used: # Sub schemas provide different views of the data to the user and the programmer, who do not need to know all the data contained in the entire database. # Sub schemas enhance security factors and prohibit data compromise. # Sub schemas aid the DBA while assuring data integrity. Each data item included in the subschema will be assigned a location in the user working area (UWA). The UWA is conceptually a loading and unloading zone, where all data provided by the DBMS in response to a CALL for data is delivered. It is also where all data to be picked up by the DBMS must be placed.


What describes only the portion of a database available to a particular user?

Subschema


What is star flake schema?

A starflake schema is a combination of a star schema and a snowflake schema. Starflake schemas are snowflake schemas where only some of the dimension tables have been denormalized. hardkingofflirt@gmail.com


Explain the three schema architecture of DBMS?

Physical schema,logical schema and sub schemas


What part of speech is the word schema?

Schema is a noun.


What is schema in mysql?

Schema is structure you created for your tables in My SQL


Which holds writable copy of AD schema?

Schema Master


Why do you need mapping between schema levels?

There is need for mappings between schema levels for visualization and schema matching. The mappings between schema levels helps in the different types of transformation.


Why should a sub schema be independent of schema?

I do not do not sens me something today