Database Schema Sample for Price Comparison Website

Hi,

I am try to conceptualize database schema that will be used for website to show different products with price from multiple retailers.

Can you please show me sample schema how to support multiple prices/attributes for single product for multiple retailers?

Thanks a lot.
LVL 2
Imran AliWeb DeveloperAsked:
Who is Participating?
 
sdstuberCommented:
basic structure would look something like this, fill in other attributes and assign data types according to the platform.

retailer (retailer_id number, retailer_name text, other attributes);

product(product_id number, product_name text, other attributes);

retailer_product(retailer_id number,product_id number, price number, other attributes);

FK between retailer_product and retailer and product tables.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.