Topic 9a
Database Fundamentals
Prior to Class
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)
Assigned Materials
- Readings
- Section 9.1, pp 470-478 in your book
In class
Discussion
Let's walk through this idea for a bit.
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
Extra Help
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.