I am just getting into some database design. I have done simple one table database stuff before but now I am trying to do some more complex stuff. Here is the problem I am trying to figure out:
What I have is a list of users:
-------------------------------
|*******USERS********|
-------------------------------
|ID|*NAME*|*PASSWORD*|
-------------------------------
ID is the key for that table, Name is a unique user name and Password is the password for that account. Now what I want to do is have each user have their own unique list of items assciated with their name. The lists would be various sizes.
---------------------------------
|*******ITEM LIST*******|
---------------------------------
|ID|*ITEM*ID*|*QUANTITY*|
---------------------------------
The ID is the key for this table, the Item id defines what item it is they want and Quantity is how many of that item they would like.
How would I set something like this up? Is it possible? I am using Access to design the database and I am going to export it to SQL SERVER 2000. In my head I have something like this pictured:
--------------------------------------------------------
|****************USERS****************|
--------------------------------------------------------
|ID|*Name*|*Password*|******List******|
--------------------------------------------------------
|**|******|**********|*----------------------------*|
|**|******|**********||The List table||
|**|******|**********|*----------------------------*|
--------------------------------------------------------
Does this make sense to anyone but me? Is there a better solution to this problem perhaps? Give me your opinions!
-alocurto
PS- How bout a hand for those diagrams 😀
The '*' is to keep the spacing
What I have is a list of users:
-------------------------------
|*******USERS********|
-------------------------------
|ID|*NAME*|*PASSWORD*|
-------------------------------
ID is the key for that table, Name is a unique user name and Password is the password for that account. Now what I want to do is have each user have their own unique list of items assciated with their name. The lists would be various sizes.
---------------------------------
|*******ITEM LIST*******|
---------------------------------
|ID|*ITEM*ID*|*QUANTITY*|
---------------------------------
The ID is the key for this table, the Item id defines what item it is they want and Quantity is how many of that item they would like.
How would I set something like this up? Is it possible? I am using Access to design the database and I am going to export it to SQL SERVER 2000. In my head I have something like this pictured:
--------------------------------------------------------
|****************USERS****************|
--------------------------------------------------------
|ID|*Name*|*Password*|******List******|
--------------------------------------------------------
|**|******|**********|*----------------------------*|
|**|******|**********||The List table||
|**|******|**********|*----------------------------*|
--------------------------------------------------------
Does this make sense to anyone but me? Is there a better solution to this problem perhaps? Give me your opinions!
-alocurto
PS- How bout a hand for those diagrams 😀
The '*' is to keep the spacing
