Constraint Violating Yak Guru
Posted - 05/01/2012 : 09:54:26
I need to design a db with tables. Users are asked questions usually to rate between two similar products such as Android and iPhone.Each product will have an image. User clicks on image that he likes and the score is saved in a the db.
What I am not sure of is how to store the 2 products in the db for easy retrieval and inserts.Also I have to keep track of each product's score.
I want each day 2 different products compared. I want to insert into the db beforehand a list of the products to compare and each day it will compare 2 products.
I thought of the following 2 tables so far:
ComparisonID QuestionID Asked Already (bit)
1 1 Yes/No
QuestionID Question Score
1 iPhone 3
2 Android 7
3 SQL 199
4 Access 98