SQL is full of difficulties & traps for the unwary. Understanding relational theory is essential for avoiding those traps, but you need to know how to map the ideas of that theory into SQL code. In SQL & Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL.