Thanks a lot Jeff. I would like to add 1 more table to that list.

1) Opening( OpenID, OpenName)

2) Resumes( ResumeID, CandidateID, LastDateOfUpdate,Resume)

3) ResumeAvailability(OpeningID, ResumeID) - (Derived Table)

4) Skills(SkillID, SkillName,SkillDuration)

5) SkillAvailability(SkillId, CandidateID) - (Derived Table)

6) OS(OperSID, OperSName, OperSDuration)

7) OSAvailability(OperSID, CandidateID) - (Derived Table)

8) InterviewDetails(InterviewID, CandidateID, DOI, Rating,Status_F) ; Date of Interview - DOI ; STATUS_F(Entries Allowed S,R,H only)

9) Interviewers( InterviewID, EmployeeID);

10) Candidate(CandidateID, FirstName, LastName, ResumeID, DOB, Gender, LastDateOfUpdate).

Now will this be the best of the Normalised set of table formed for the discussed requirement?

Please Help me understanding this.