function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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