Dbase design question for 2 tables
Posted: Thu Jul 27, 2006 1:54 pm
Was wondering which is there better database design situation:
1.
user
------
user_id
user_name
item
------
item_id
user_id
item_name
2.
user
------
user_id
user_name
item
------
item_id
item_name
user_item
----------
user_id
item_id
1.
user
------
user_id
user_name
item
------
item_id
user_id
item_name
2.
user
------
user_id
user_name
item
------
item_id
item_name
user_item
----------
user_id
item_id