Re: Getting ready to setup a database for selling stuff

[Jon Stephens]

Attributes in a 1-1 correspondence should generally go in the same table.

If each item has one and only one price, then items and prices should be in the same table; an items table in this case might include columns for item ID, item name, price, description, and so forth.

You can use one of our sample databases as a guide, an example being the Sakila database.

cheers

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle