Question

In: Computer Science

Discuss the concept of data independence with respect to the three schema architecture.

Discuss the concept of data independence with respect to the three schema architecture.

Solutions

Expert Solution

ANSWER -

DATA INDEPENDENCE -

It is the capacity to change the schema of one level of three schema architecture in DBMS without having to change the next higher level of the schema. This can be explained with three schema architecture.

THREE SCHEMA ARCHITECTURE -

In DBMS, the main goal of three schema architecture is to separate the user level/external level from the physical database. There 3 levels , namely -

  1. Internal level - It includes internal schema, which describes the physical storage of database.
  2. Conceptual level - Includes conceptual schema, which hides the details of physical storage and data is represented in form of database tables.
  3. External level - Includes external view, which specifies the data which particular user group are interested in and hiding the rest of database from the user.

The concept of data independence with respect to the three schema architecture , it is classified into two -

  • Logical Data Independence - It is ability to change or modify the conceptual schema of the conceptual level without having to change the external schema. It is difficult to achieve compared to the physical data independence because the changes made in conceptual level affects the view in external level.
  • Physical Data Independence - It is the ability to change or modify the internal schema of the internal level without having to change the conceptual schema, hence not affecting the external schema. It is easier to achieve and is used and implemented in most of the database management system.

This is the concept of data independency with respect to three-schema architecture.

=================================END===============================

Please comment if u need any more info. Please do leave a like, it would mean a lot. Thanks :)


Related Solutions

Discuss the three-schema architecture and its benefits for database development and design.
Discuss the three-schema architecture and its benefits for database development and design.
Describe the three-schema architecture. Why do we need mappings among schema levels?
Describe the three-schema architecture. Why do we need mappings among schema levels?
Explain the concept of efficient market hypothesis and discuss the practical implication with respect to the...
Explain the concept of efficient market hypothesis and discuss the practical implication with respect to the Ghana Stock Exchange Maximum page(5 minus references) Minimum pages(3 minus references)
Discuss how the concept of statistical independence underlies statistical hypothesis testing in general. Based on statistical...
Discuss how the concept of statistical independence underlies statistical hypothesis testing in general. Based on statistical analysis, are we justified in asserting that two variables are statistically dependent? Why or why not? Explain why researchers typically focus on statistical independence rather than statistical dependence.
Discuss how the concept of statistical independence underlies statistical hypothesis testing in general. Based on statistical...
Discuss how the concept of statistical independence underlies statistical hypothesis testing in general. Based on statistical analysis, are we justified in asserting that two variables are statistically dependent? Why or why not? Explain why researchers typically focus on statistical independence rather than statistical dependence.
Describe the physiology of the pancreas with respect to the three types of cells. Discuss this...
Describe the physiology of the pancreas with respect to the three types of cells. Discuss this relationship to the endocrinology of blood sugar and homeostasis. What is ketosis? Discuss the cause, symptomology and prevention of ketosis.  
Discuss the three possible situations that can arise with respect to contributory claims
Discuss the three possible situations that can arise with respect to contributory claims
Computer Architecture Theme: External Memory Discuss the effectiveness of data striping in RAID 0 for the...
Computer Architecture Theme: External Memory Discuss the effectiveness of data striping in RAID 0 for the following two cases: A single process requests large data sets Multiple processes request several small sized data
explain the democratic concept or principle represented in the Declaration of Independence and/or the Constitution.
explain the democratic concept or principle represented in the Declaration of Independence and/or the Constitution.
Discuss the evolution and significance of the profession of architecture.
Discuss the evolution and significance of the profession of architecture.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT