Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established. A hefty part of designing a ...

Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables. In an earlier tip, I showed a way to ...