Topic 9a
Database Fundamentals
Learning Objectives
By the end of this topic students should be able to:
- Explain the difference between a schema and a subschema.
- Given a particular domain and one or more “roles” within that domain, identify data that would be part of the subschema for each “role”
- Explain the different layers in a modern database implementation (Figure 9.2)
Learning Materials
- Readings
- Section 9.1, pp 470-478 in your book
Checking for Understanding
Answer the following questions from your textbook. The answers to all Q&E questions are in the back of your book in Appendix F.
- p 478, #1
- p 478, #3
Additional Guidance
If you are still struggling with the material in this topic, the following material may help.Further Information
If you understand this material and are using this in your own courses, you might find the following material beneficial. This material is a supplement to this course and your understanding of this is not assessed.- NA