You change the details the manufacturer table

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.