# Setting up first database

**URL:** <https://forum.kirupa.com/t/setting-up-first-database/91705>\
**Category:** Uncategorized\
**Created:** [October 7, 2003, 10:33pm UTC](https://forum.kirupa.com/t/setting-up-first-database/91705 "2003-10-07T22:33:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeremy](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@jeremy](https://forum.kirupa.com/u/jeremy)\
**Post date:** [October 7, 2003, 10:33pm UTC](https://forum.kirupa.com/t/setting-up-first-database/91705/1 "2003-10-07T22:33:17Z")

</div>

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.