Many-one Mapping

[yasmine]

Hi friends,

Can anyone tell me how can I do many to one mapping in MySQL?

That is what i'm asking is,
for example,
there is a single supervisor for 12 associates, then how can I do many to one mapping (Associates to Supervisor) for providing a single feedback to all the associates.
How should i create database structure for this????

Plz....Help me out.........

Thanx n Regards
Yas

[debasisdas]

You should have a supervisor column in the associates table and add self reference to supervisor column.