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