Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
scm22ri
Starting Member
3 Posts |
Posted - 2012-11-22 : 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 columnIDYearMake Model Car ColumnIDUserIDYearMakeModel PriceMileageColor Transmission StateCity |
|
SqlGirl87
Starting Member
26 Posts |
Posted - 2012-11-23 : 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 columnIDYearMake Model Car ColumnIDUserIDYearMakeModel PriceMileageColor Transmission StateCity
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. |
|
|
|
|
|