A rather complicated database scenario

[tektippee]

How do I handle this Mysql 4-table scenario:

SCHOOLS to STUDENTS is a 1 to many relationship.
AUCTIONS to PRIZES is also 1 to many.

Now, a school can participate in many auctions,
or one auction can be registered with many schools.
That is, SCHOOLS to AUCTIONS is a many to many realtionship.

Since STUDENTS to PRIZES can be 1 to many,
how do I handle this table setup - to query winners of prizes or auctions?

 

[vacunita]

You'd want to 'normalize' it by having a middle man table "School_Auctions" that makes the relationships 1 to many instead of many to many.

You can use that table in your query to identify schools that are involved in the same auction or Auctions pertaining to the same school etc...








----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.