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

[Chris Blessing]

How about a separate hotel table which would accept racetrackid and
driverid?

Hotels (PK HotelID, FK RaceTrackID, FK DriverID, Name, Address, ...)

The RaceTrackID and DriverID would be M-M to their respective PK's.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of David Shadovitz
Sent: Thursday, January 24, 2002 9:18 PM
To: thelist at lists.evolt.org
Subject: [thelist] Database design - where does that letter go?


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

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !