Topic awaiting preservation: Wierd database puzzle (Page 1 of 1)

For me it's complex, anyways.

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.
But now, SCHOOLS to AUCTIONS is many to many,
i.e., a school can participate in many auctions,
or one auction can be registered with many schools.

My question:
Since STUDENTS to PRIZES can be 1 to many,
how do I handle this table setup - to query winners of the prizes?

you'll need to provide more details for an example, but you'll need a multi join.

A many to many consists of 3 tables.

| SCHOOLS |1---M|SCHOOLS_AUCTION_WEAK_ENTITY|M---1|AUCTION|

Additionally, try drawing an ERD (Entity Relationship Diagram) of the database using DIA (free open source diagramming tool).



- AIM: MASKKKK

01001101011000010111001101101011011010110110101101101011

(Edited by Maskkkk on 02-22-2010 16:01)