+ Start a Discussion
asish1989asish1989 

Designing database

Hi all

 

I want to design an application in which an employees table present which keeps all information about an employee.A Lead(project manager ) is also an employee.Lead 's information also is presnt in employee.A general employee has more then one Lead.that means he is under more than one Lead.so how can I design database.

1-how can I get total number of Lead

2-how can I get Lead of a particular employee..

Please suggest me what will I do ?.

I tried by using self join but I am unable to get infomation if an employee has more than one Lead.

So please help me as soon as possible ......

 

Thanks

asish