Best unofficial Apache Server developers community |
|
i will create schema the database MySQL. There are username, password etc and rating system and available in month. Standard it looks like this: id | username | password | january | february | march | rating1 | rating2| rating3 | 1 | john | xxx | 1 | 0 | 1 | 3 | 3 | 6 2 | amy | xxx | 1 | 1 | 0 | 1 | 6 | 3 if a user buys article then must add a rating (1,2,3). if chose 2 in John then rating2 +1 id | username | password | january | february | march | rating1 | rating2| rating3 | 1 | john | xxx | 1 | 0 | 1 | 3 | 4 | 6 2 | amy | xxx | 1 | 1 | 0 | 1 | 6 | 3 january, february (1 - available, 0 - not available)etc set himself John or Amy. this is good? Should I create separate tables for Januar/feb/march and rating1/2/3? Maybe only for rating?
posted via StackOverflow
|
|
 
|
im not a hard core database designer but at a glance this is schema is not normalized. if you can create a separate table for month and rating would be better please find the below sample d | username | password 1 | john | xxx id | month | rating 1 | 1 | 3 MonthID | MonthName 1 | January How ever this sujjestion may not be the ideal solution for your proposed database. |