0
overall logical structure of data
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
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.
How are the internal external and conceptual schemas related to concept of logical and physical data independence?
The internal schema represents the physical storage structure of data, the external schema represents how different users view the data, and the conceptual schema defines the logical structure of the entire database. Logical data independence means that the conceptual schema can change without affecting the external schemas, while physical data independence means that changes in the physical storage structures do not affect the conceptual or external schemas.
Why is schema important to learning?
Schema is important to learning because it helps individuals organize and interpret new information based on their existing knowledge and experiences. It provides a framework for understanding and processing new information, making it easier for learners to make connections and retain knowledge. By activating and building on existing schema, individuals can enhance their learning and make new information more meaningful and memorable.
What is these terms is defined as a wise saying that describes the lesson taught at the end of a fable?
A moral is defined as a wise saying that describes the lesson taught at the end of a fable.
Which word best describes the character in humanism?
"Empathetic" is a word that best describes the character in humanism since humanism emphasizes the importance of understanding and valuing others' experiences and perspectives.
What best describes an active directory forest?
A collection of domains that share a common schema
What is global conceptual schema?
The enterprise view of the data is described by the global conceptual schema (GCS), which is global because it describes the logical structure of the data at all the sites.
What is schema instance?
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
What is Schema and instances?
In DBMS,Schema is the overall Design of the Database.Instance is the information stored in the Database at a particular moment.In programming,you declare a variable which corresponds to "Schema".But its values changes as and when required which corresponds to "Instance". Google about levels of Database Abstraction. Physical Schema describes database design at physical level while a logical schema describes the database design at the logical level.A database may also have several schemas at the view level, sometimes called subschemas, that describe different views of the database.
What is xml schema?
XML Schema is an XML-based alternative to DTD.An XML schema describes the structure of an XML document.The XML Schema language is also referred to as XML Schema Definition (XSD).An XML schema is a description of a type of XML document, typically expressed in terms of constraints on the structure and content of documents of that type, above and beyond the basic syntactical constraints imposed by XML itself.
Discuss the basic differences between external schema conceptual schema and internal schema?
The internal schema describes how the data will be physically stored and accessed, using the facilities provided by a particular DBMS. For example, the data might be organized so that all the insurance policies belonging to a given customer were stored close together, allowing them all to be retrieved into the computer's memory in a single operation. The conceptual schema (sometimes called the logical schema) describes the stored data in terms of the data model of the DBMS. In a relational DBMS, the conceptual schema describes all relations that are stored in the database The external schemasspecify views that enable different users of the data to see it in different ways. As a simple example, some users of policy data might not require details of the commission paid. By providing them with a view that excludes the Commission Rate column, we would not only shield them from unwanted (and perhaps unauthorized) information, but also insulate them from changes that might be made to the format of that data.by:mohammed abu Lamdy
What is a schema?
A schema is a way to organize and define the structure of a database, including tables, fields, relationships, and constraints. It serves as a blueprint for how data is stored and accessed in a database management system. It helps ensure data integrity and consistency.
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
Another term for document properties?
The properties of a database are commonly called a schema. The schema describes the tables in the database, the fields inside each table, the contents of each field, etc.
What is the difference between data model and schema in database?
As I understand it, a database schema is a physical entity, it describes the structure of exactly how the data is stored and is itself stored by DBMS for reference. Data model, on the other hand, is an abstract representation of database.
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.
Explain the three schema architecture of DBMS?
Physical schema,logical schema and sub schemas
