well I am configuring my first database, it will catalog products. Basically this is how I currently have it set up.
table -> product
ID
product
amount
supplier
price
table - > supplier
ID
name
address
URL
email
logo
phone
The most common thing will be for the user to look up a specific product, and compare the prices/locations/suppliers.
I also would like to have supplier pages, where the user can view a ‘profile’ of the certain supplier.
It seems like two DB’s (*edit: tables) would be the way to go, but I’m still not sure if that is enough, of if I am overlooking something.
Let me hear your thoughts.
thank you.
