Improve Efficiency of Job Resumes Manage Database Schema

access China
  • 13 years ago

    I try to print the "Relation", but it's in a big mass.

    Object/Sheet/
    Many sheets there

    Sheet/Awards: Awards Numbers; Applicant ID; Awards; Year; Reference Numbers
    Sheet/Certificate: Certificate Numbers; Applicant ID; Certificate; Institute; Keyword; City; Country; Reference Numbers
    Sheet/Education: Education Numbers; Applicant ID; Education Degree Type; Education Course Name; Education Institution Name; KeyWord; City; Country; Start Year; End Year; Education Graduated On; Education Comments; Reference Numbers
    Sheet/Education & Experience: Number; Applicant ID; Employee Last Name; Employee First Name; Education Degree Type; Education Course Name; Education Institution Name; Education Graduated On; Education Comments; Language; Licenses Issue Date; Licenses Renewal Date; Licenses ID; Licenses Description; Licenses Comments; Training or Skills Completion Date; Training or Skills Group Name; Training or Skills Training Name; Training or Skills Proficiency; Training or Skills Renewal Date; Training or Skills Renewal Date Comments; Awards; Certificate; Work Experience; Reference; Reference Phone; Reference Business Phone; Reference Mobile or Cellular; Reference Email Address; Reference Company; Reference Position
    Sheet/Employee Name: Applicant ID; First Name; Last Name; Marital Status Single or Married; Date of Birth yyyy m d; Age; Dependents; Gender Male or Female; disabled; disabilityPerCent; DetailsOfDisability; Address 1; Address 2; City or Township; State or Province; Country; Postal Code; Home Phone; Home Phone 2; Home Phone 3; Business Phone; Fax Number; Mobile or Cellular; Pager Number; Email Address 1; Email Address 2; Email Address 3; Web Site; Prefer Position; Ethnic Origin; Citizenship; Visa Type; Visa Expires; Employee Type Full Time Regular or Part Time Regular; ExpectedReturnUSD; Apply Job; 3YearProfessionalHighSchool; 3YearProfessionalCollege; 3YearProfessionalMaster
    Sheet/Language: Numbers; Applicant ID; Language
    Sheet/Licenses: Licenses Numbers; Applicant ID; Licenses Issue Date; Licenses Renewal Date; Licenses ID; Licenses Description; Licenses Comments; Reference Numbers
    Sheet/Reference: Reference Numbers; Awards Numbers; Certificate Numbers; Education Numbers; Licenses Numbers; Training or Skills Numbers; Work Experience Numbers; Reference; Reference Phone; Reference Business Phone; Reference Mobile or Cellular; Reference Email Address; Reference Company; Reference Position
    Sheet/Training or Skills: Training or Skills Numbers; Applicant ID; Completion Date; Institute Name; TrainingName; TrainingSubjects; TrainingProficiency; City; Country; Start; End; Years; Training Renewal Date; Training Renewal Date Comments; Reference Numbers
    Sheet/Work Experience: Work Experience Numbers; Applicant ID; Company; Work Experience; Position; SalaryUSD; Start Year; End Year; Years; Location city; Location Country; Reference Numbers

    Too many data to record

    In trouble relation

    I must sort which data is necessary.

    And redesign the sheets

    Any suggest

     

     

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil.” - Donald Knuth