[thelist] Database design - where does that letter go?

David Shadovitz david_shadovitz at xontech.com
Thu Jan 24 20:13:01 CST 2002


I'm hoping some kind soul(s) can help me with this database design
issue.

Let's say we're dealing with NASCAR.  I've got these tables:

RaceTracks {PK RaceTrackID, RaceTrackName}
Drivers {PK DriverID, DriverName}

Since there's a many-to-many relationship between RaceTracks and
Drivers:
RaceTracksDrivers {PK RaceTrackID, PK DriverID}

And let's say we've got a guy with a radar gun walking around:
RaceData {PK RaceTrackID, PK DriverID, PK Time, Speed}

OK, here's where my brain says "No.":
A driver gets a letter from his sponsor telling him the next 4
RaceTracks he should go to, and what hotel to stay at.  What is the
correct representation for these letters?

I'm on digest, so please copy me at david at shadovitz.com and
david_shadovitz at xontech.com.

I will endeavor to pay for this with some good ColdFusion and/or Oracle
and/or Software Engineering tips.

Thanks.
-David




More information about the thelist mailing list