Multiple Values in One Column or Many Columns?
If I want to store and retrieve the following data in a database, what is the optimal way to do so--I am asking specifically for the "Fruits_you_like" column?
Fruits_you_like will consist of 30 different fruits. Would it be best to have one column for each fruit and use boolean 1/0 like this:
Name, Phone_Number, Email_Address, Apples, Oranges, Pears, Cherries, Strawberries
Or would it be better to only have four columns (Name, Phone_Number, Email_Address, Fruits_you_like)? If it is best to use only four columns, what should the Fruits_you_like column be? An array? Multi-dimensional array?