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

Answers & Guidance

The answers to the CFU questions above are provided in the back of the book. The following videos explain how we would arrive at some of those answers.

• CFU 478.1
• CFU 478.3