I'm designing a website for a local Sub Shop and I need some help with the database layout.
There are ten categories of food: Subs, Footlongs, Sandwiches, Platters, Soups, Chineese Food, Eggrolls, Side Orders, Drink and Extras.
Each item in each category has a price, but some has more than one, for example:
Cheese Steak Sub: 6" price and 12" price.
Shrimp Fried Rice: Pint price and Quart price.
Drinks: Small Price, Medium Price, Large Price.
While Platters, Sandiches, Soups and some others have only one size/price.
How should I handle this? Throw everything into one table with a bunch of columns? I could use an example if that's not asking for too much.