Review Questions

1.Describe the three-tier ANSI-SPARC architecture. Why do we need mappings between different schema levels? How do different schema definition languages support this architecture?
2.Discuss the advantages and characteristics of the three-tier architecture.
3.Discuss the concept of data independence and explain its importance in a database environment.
4.What is logical data independence and why is it important?
5.What is the difference between physical data independence and logical data independence?
6.How does the ANSI-SPARC three-tier architecture address the issue of data independence?
7.Explain the difference between external, conceptual and internal schemas. How are these different schema layers related to the concepts ...

Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.