Schema and Subschema in DBMS
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Schema and Subschema in DBMS
In database management systems (DBMS), a schema is a logical description of the entire database, including its tables, relationships, and constraints. It provides a framework for organizing data and ensures that data is stored consistently and accurately. A schema defines the structure of the database and describes how data is stored, retrieved, and updated.
A subschema is a subset of the schema that defines the way data is viewed by a particular user or application. It specifies the portions of the database that are relevant to the user or application and determines the operations that can be performed on that data. In other words, a subschema defines the portion of the schema that is visible to a particular user or application and provides a customized view of the data.
A subschema is often used to provide different views of the data to different users or applications. For example, an accounting department might have a subschema that shows only financial data, while a sales department might have a subschema that shows only customer data. By creating different subschemas for different users or applications, a database can provide customized views of the data that are tailored to each user’s needs.
The relationship between a schema and a subschema is hierarchical, with the schema being the top-level structure and the subschemas being the lower-level structures. A schema can have multiple subschemas associated with it, each defining a different view of the data. When a user or application accesses the database, it is typically through a subschema rather than the full schema.
One of the benefits of using subschemas is that they provide a way to control access to the data. By creating subschemas that only show certain portions of the data, a database administrator can ensure that users or applications only have access to the data they need. This can help to prevent unauthorized access to sensitive data.
Another benefit of using subschemas is that they can improve performance. By creating subschemas that only show relevant portions of the data, queries can be optimized for speed and efficiency. This can help to reduce the amount of time it takes to retrieve or update data.
In summary, a schema is a logical description of the entire database, while a subschema is a subset of the schema that defines a customized view of the data for a particular user or application. Subschemas provide a way to control access to the data and can improve performance by optimizing queries. By using subschemas, a database can provide customized views of the data that are tailored to each user’s needs.
Schema and Subschema in DBMS
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow