Database management systems notes
Capstone: Designing a Real Schema
One system, designed end to end, using every part of this course. Every section is a drawn page beside a clear written explanation, about 24 minutes in all.
- Chapter 34 of 34
- About 24 minutes
- 7 sections
Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.
In this chapter
- The requirements, and the questions they hide
- The ER model
- The schema
- Checking the design formally
- The hard part: two people, one seat
- Indexing for the real queries
- Planning for growth
More Database management systems
Read the whole chapter
Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.
DSA comes with the all labs plan and every ChaiCode batch.