View Full Version : Is my table structure ok?


NewbieDB
05-14-2007, 12:56 AM
Hi,
Thanks for taking time out reading my thread!
I want to start entering data, but i'm not to sure weather my relationship structure is good enough to start inputing.

Heres a pic of my relationships
http://img201.imageshack.us/my.php?image=almostdoneae0.jpg


Thanks.

CraigDolphin
05-14-2007, 09:20 AM
Hard to comment without a good understanding of your real world business model. Some thoughts anyways...

I'm particularly uncertain about the 'Name' table and associated tables (Junction, Gender, Origin).

What are the entities in 'Names' in the real world? How do they relate to Companies, Orders/OrderDetails, and Products?

Also, a product might belong to more than one category thereby requiring a junction table between Products and Categories