Computer Science › Section J · Database systems › Topic J.2
The relational model
The relational model pictures every database as a set of simple tables. Designing those tables well, and knowing how to combine them, is the foundation of almost every business database in use today.
In this topic
- Data as tables
- Keys
- Relationships between relations
- One big table and its troubles
- Worked example: splitting the clinic log
- Normalisation
- Lossless and lossy decompositions
- Selecting rows and projecting columns
- Joining relations
- Worked example: who owns a cat?
- Common mistakes to avoid
- Key takeaways
This topic is part of Wuanberri Pro. Checking your access…