scm22ri
Starting Member
USA
3 Posts |
Posted - 11/22/2012 : 17:27:57
|
I have a question regarding how to design/set up my database. The year, make and model and constants. Meaning I (the webmaster) is going to be supplying that information. Everything else the user is going to input. My question is, in my second column should I also include the year, make and model?
User column ID Year Make Model
Car Column ID UserID Year Make Model Price Mileage Color Transmission State City |
|
SqlGirl87
Starting Member
26 Posts |
Posted - 11/23/2012 : 17:42:40
|
quote: Originally posted by scm22ri
I have a question regarding how to design/set up my database. The year, make and model and constants. Meaning I (the webmaster) is going to be supplying that information. Everything else the user is going to input. My question is, in my second column should I also include the year, make and model?
User column ID Year Make Model
Car Column ID UserID Year Make Model Price Mileage Color Transmission State City
I would take them out of the first table, and use the carID are the FK in the user table, rather than the user in the car one. |
 |
|