Solved

Database Schema Sample for Price Comparison Website

Posted on 2016-10-24
2
36 Views
Last Modified: 2016-11-12
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.
0
Comment
Question by:Imran Ali
2 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points (awarded by participants)
ID: 41857619
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Creating and Managing Databases with phpMyAdmin in cPanel.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question