hello,
Can someone please tell me if the table relationships are OK.. I have a database which stores people's information and the seminars they have registered for.. Every seminar should have a primary location and date and could be broadcasted over several alternate locations and could run for one or more days at a stretch... Now I am storing the registration information and payments made in "accounting" table and meals (buffet, lunch, dinner) ordered in "food" table... Since meals could be ordered for more than one day if a seminar runs for multiple days, should I have the "food" table as in RELATION1.JPG or RELATION2.JPG
Thank you
Ivi
Can someone please tell me if the table relationships are OK.. I have a database which stores people's information and the seminars they have registered for.. Every seminar should have a primary location and date and could be broadcasted over several alternate locations and could run for one or more days at a stretch... Now I am storing the registration information and payments made in "accounting" table and meals (buffet, lunch, dinner) ordered in "food" table... Since meals could be ordered for more than one day if a seminar runs for multiple days, should I have the "food" table as in RELATION1.JPG or RELATION2.JPG
Thank you
Ivi
Attachments
Last edited:
