Welcome Guest, Not a member yet? Register   Sign In
Racing Database Design Inquiry
#5

[eluser]zimco[/eluser]
Many thanks to all for the thoughtful responses. Each of you has pointed out some things i had not considered until you mentioned it, and have helped me to make better decisions for the database design.

--webthink special thanks for pointing out the lack of necessity for the car_scores table; as i was debating whether i really needed it or not as the database should not exceed 200 cars and i would think the server should be able to query and do the calculations relatively fast on such a small number. However, the database design books i've been reading lately always seem to prefer having the extra table rather than putting it in a column of the cars table, like you proposed.


Messages In This Thread
Racing Database Design Inquiry - by El Forum - 03-25-2008, 08:43 AM
Racing Database Design Inquiry - by El Forum - 03-25-2008, 09:41 AM
Racing Database Design Inquiry - by El Forum - 03-25-2008, 11:02 AM
Racing Database Design Inquiry - by El Forum - 03-25-2008, 11:08 AM
Racing Database Design Inquiry - by El Forum - 03-25-2008, 12:06 PM



Theme © iAndrew 2016 - Forum software by © MyBB