In order to avoid misunderstandings, I will be describing various features of the relational model in detail, as well as showing how to use SQL to conform to those features.
I will assume you are sufficiently experienced in database matters to understand why,
- the notion of a key makes sense, or
- why you sometimes need to do a join, or
- why many to many relationships need to be supported.