0
The schema is the physical arrangement of the data as it appears in the DBMS. The sub-schema is the logical view of the data as it appears to the application program.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Explain the three schema architecture of DBMS?
Physical schema,logical schema and sub schemas
Why should a sub schema be independent of schema?
I do not do not sens me something today
What is schema and sub-schema?
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.
What are database schema and sub-schemas?
A database schema is an actual plan for a database system. Sub-schemas are separate divisions that are used to achieve the plan for the database system.
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.
Difference between schema sub schema and instance in DBMS in detail?
the overall logical data base description is referred to as a schema. it is sometimes also referred to as an overall modal of the data, a conceptual modal of the data, a conceptual schema
What schemas do you use in Multidimensional Modelling?
In Multidimensional Modelling, common schemas used are Star Schema and Snowflake Schema. Star Schema involves a central fact table connected to multiple dimension tables, while Snowflake Schema normalizes the dimension tables by further breaking them down into sub-dimension tables. These schemas help organize data hierarchically for efficient querying and analysis in multidimensional databases.
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
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.
