54 CHAPTER 2 ■ INTRODUCING RELATIONAL DATABASES
Figure 2-28. Establishing a one-to-many relationship
In Figure 2-28, the Player table contains a column called PlayerFormats. An alarm should already be ringing, because the column name is plural. Columns should contain single pieces of information, rather than several. So then, say that every Player has only one supported Format. If that were the case, you would create a new table called Format, which is in a one-to-many relationship with the Player table, much as in Figure 2-29.