[SQL Server] I wish to compose Normalised tables for the below requirment Please Help. |
| I wish to compose Normalised tables for the below requirment Please Help. Posted: 17 Mar 2013 06:51 AM PDT There is requirement as below to create the Data Model for estimation in No of tables as of nowOpeningsResumes Available Per OpeningCandidates ContactedSkills Required(Programing Langs Only: JAVA/.NET/C C++/Perl etc)OS Knowledge (Eq. Windows/Linux/UNIX etc)Candidates Status.(Reject/Select/Hold)Interview detailsAssumption: CandidateID created only when ResumeID available for a candidate once contacted.I Just gave the crack which is below. Please correct to the most granulized form,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, EmployeeID, CandidateID, DOI, Rating,Status_F) ; Date of Interview - DOI ; STATUS_F(Entries Allowed S,R,H only)Can you please guide me so to make this more appropriate to real life. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment