0
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.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
What describes only the portion of a database available to a particular user?
Subschema
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.
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.
A detailed description of all data used in the database IS CALLED?
A detailed description of all data used in the database is called a data dictionary. It centralizes information about the structure of the database, including data types, relationships, constraints, and metadata. This resource is crucial for understanding and managing the database effectively.
Data base state vs database schema?
The database state refers to the current data stored in the database, including all records and their values. On the other hand, the database schema refers to the structure of the database, including tables, columns, constraints, and relationships. The schema defines how the data is organized and stored in the database.
Define domain with respect to dbms?
In database technology, domain refers to the description of an attribute's allowed values. The physical description is a set of values the attribute can have, and the semantic, or logical, description is the meaning of the attribute.
What is the best description of a database management system?
Database Management System is a software package with computer programs that control the creation, maintenance, and the use of a database. It allows organizations to conveniently develop databases for various applications by database administrators and other specialists. A database is an integrated collection of data records, files, and other database objects. A DBMS allows different user application programs to concurrently access the same database.
A database is self describing what does this mean?
A self-describing database is one that contains metadata or documentation within the database itself that defines the structure, organization, and relationships of the data. This allows users and applications to understand and manipulate the database without relying on external resources or knowledge.
What is the difference between data model and database model?
A database is a collection of tables that is used for some purpose (typically an application of some sort). A database model is a description of that database, and describes how the tables relate to each other. Typically, a model is designed first, then the actual database is implemented using the model as a blueprint.
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 high-level description of a conceptual data?
A conceptual data model is a high-level overview of the structure and relationships within a database. It focuses on the entities, attributes, and relationships between entities without going into the specifics of how the data will be implemented in a physical database. It serves as a blueprint for designing a database system.
How do you document a database?
Two standard ways to document a database are to create a relational diagram and a data dictionary.A relational diagram will display all the tables in a database with links to joining tables utilizing the primary and foreign keys. For a more detailed description visit- http://www.utexas.edu/its/windows/database/datamodeling/dm/erintro.htmlA data dictionary is a reference guide of all the tables and fields in a database and the use of each object.
