Let's say I'm designing a catering website where a customer can view a list of items to order from. This list would come from the database, and the table would look like this:
id | name | description | course | price | cost
-----------------------------------------------------------------
1 | Pizza| Chicago style, of course! | entree | 20.00 | 10.00
Now let's say I wanted to display allergy information for each item. Since there can be multiple allergens for each item, I'm thinking that a separate table would be better.
For example, if my allergen table looks like this:
id | allergen
-------------
1 | wheat
2 | eggs
3 | dairy
4 | soy
5 | fish
6 | nuts
How can I link the two tables to show that the Pizza contains wheat and dairy?
Is having separate tables the correct approach? Looking for suggestions, I've never designed a database before.