August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ... |