design help
design help
- Subject: design help
- From: Michael Engelhart <email@hidden>
- Date: Mon, 30 Aug 2004 09:47:08 -0500
I have a database modeling question I'm struggling with.
I have a travel FrequentTraveler table that stores frequent traveler
numbers (airline frequent flyer numbers, car rental agency requent
renter numbers, hotel frequent guest numbers, etc).
I have a CarReservation table that stores data associated with a car
reservation. Two of the allowable pieces of information are a single
airline frequent flyer number and a single car rental agency frequent
renter number. So for example if you rent a car from Hertz you could
enter your American AIrlines frequent flyer number and your Hertz
Frequent Renter number and get credit for both from Hertz. My
original design idea would be to keep all a customers frequent
traveler numbers (some customers can have as many as 20 or 30 if they
are business travelers) in the FrequentTraveler table in a one-to-many
relationship. I'm not sure how to model this relationship back to
FrequentTraveler so that I just store FrequentTravelId's in my
CarReservation table.
Thanks
Mike
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.