Tags Microsoft Windows Database Programming Windows Server 2003

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Electronics>Computers

What is schema and sub-schema?

Anonymous

∙ 15y ago

Updated: 11/6/2022

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.

Wiki User

∙ 15y ago

Still curious? Ask our experts.

Chat with our AI personalities

Ezra

Faith is not about having all the answers, but learning to ask the right questions.

Chat with Ezra

Judy

Simplicity is my specialty.

Chat with Judy

Fran

I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.

Chat with Fran

More answers

difference between schema and subschema

Kiranjeet Kaur ∙

Lvl 2

∙ 4y ago

Schema

Wiki User

∙ 12y ago

Add your answer:

Earn +20 pts

Q: What is schema and sub-schema?

Write your answer...

Submit

Still have questions?

imp

Trending Questions

How does somebody turn on sticky keys on on a mac? Do you need Windows 7 to install Windows 8? What are the best free methods for removal of spyware from a computer? How do you remotely activate gps location on android phone? Has anyone ever heard of a fletcher special Ithaca serial number 58655? When you type a function in Excel what appears after you type the opening parenthesis? Is the default user the profile that is merged into each user profile when the user is logged on? Where is the data link connector on a 1993 F-53 motor home chassis? Rename a file in Excel? What does Caret browsing mean? What is script file? The maximum cable length for a serial cable according to RS-232 standards is 50 feet? How much is 64GB in MB? Who wrote the play the mouse trap? Where data packets are transmitted through different layers of the OSI model? Can you use a French socket in Denmark? What letter indicates the route taken by Spanish explorer Hernando de Soto? How do you format a laptop? What graph shows how volume changes over time in excel? Where can one get help and support for Dell speakers?

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.

Which holds writable copy of AD schema?

Schema Master

What is schema in mysql?

Schema is structure you created for your tables in My SQL

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

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.