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

Jason Lustig lustig at acsu.buffalo.edu
Thu Jan 24 22:42:01 CST 2002


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

Actually it probably would be better if you normalized that:

HotelReservs (PK ReservID, FK HotelID, FK RaceTrackID, FK DriverID )

Hotels (PK HotelID, Name, Address, ... )

--Jason



More information about the thelist mailing list