Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    DB Tata Tchitchikoshvili HW Descriptions

    Uploaded by

    Tata Tchitchikoshvili
    The document describes a relational database model for a recruitment company. The database contains tables for companies, job platforms, vacancies, recruiters, skills, applicants, universities, and education. Relationships exist between tables like companies and recruiters through vacancies, and universities and applicants through education. The model aims to efficiently match applicants to job openings by storing relevant applicant and job data, and linking them through skills, education history, and other attributes.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    DB Tata Tchitchikoshvili HW Descriptions

    Uploaded by

    Tata Tchitchikoshvili
    29 views5 pages
    The document describes a relational database model for a recruitment company. The database contains tables for companies, job platforms, vacancies, recruiters, skills, applicants, universities, and education. Relationships exist between tables like companies and recruiters through vacancies, and universities and applicants through education. The model aims to efficiently match applicants to job openings by storing relevant applicant and job data, and linking them through skills, education history, and other attributes.

    Original Title

    DB_Tata_Tchitchikoshvili_HW_descriptions

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes a relational database model for a recruitment company. The database contains tables for companies, job platforms, vacancies, recruiters, skills, applicants, universities, and education. Relationships exist between tables like companies and recruiters through vacancies, and universities and applicants through education. The model aims to efficiently match applicants to job openings by storing relevant applicant and job data, and linking them through skills, education history, and other attributes.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    29 views5 pages

    DB Tata Tchitchikoshvili HW Descriptions

    Uploaded by

    Tata Tchitchikoshvili
    The document describes a relational database model for a recruitment company. The database contains tables for companies, job platforms, vacancies, recruiters, skills, applicants, universities, and education. Relationships exist between tables like companies and recruiters through vacancies, and universities and applicants through education. The model aims to efficiently match applicants to job openings by storing relevant applicant and job data, and linking them through skills, education history, and other attributes.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 5

    Business Model

    Recruitment Company
    DAESP23 - Tata Tchitchikoshvili
    1 BUSINESS DESCRIPTION

    Businesses that conduct recruitment serve as a middleman between companies and job seekers.

    For the benefit of the companies, they look for skilled candidates to fill open positions. The

    Company is quite successful. It currently has 30+ recruiters, who have helped 500+ companies to

    fill 2300+ positions. So, matching every position to suitable candidates manually is difficult since

    there is high demand, and so many applicants. Therefore, using relational databases, finding a

    possible employee becomes easier.

    Businesses get to the recruitment company when they need to find an employee for the vacant

    position, then they are addressed with one or sometimes more than one recruiter who help

    them to find a suitable match for them. A recruiter posts a vacancy on a platform, or it can be a

    non-open vacancy. Companies often have strong requirements about the skills for the possible

    employee. With the help of the database of applicants with a list of soft and hard skills, the

    recruiter easily matches possible candidates for a vacant position. Other than the set of skills,

    education and graduated university is also a very important detail about the applicant. So, there

    is a distinct table in the database about education.

    There are tables about companies, recruiters, applicants, skills, platforms, universities, etc.

    There is a many-to-many relationship between companies and recruiters through the bridge of

    vacancies’ table (a recruiter serves for several companies and in some cases there are more than

    one recruiter working for one position depending on the size of company and the position).

    Also, between the universities and applicants tables through the bridge of education table (a

    student can have got education from several universities and there are many student in a

    university.

    As the skills are one of the most important factors for matching there is a distinct table of

    applicant skills that connects skills’ and applicants’ tables.


    2 MODEL DESCRIPTION

    2.1 DEFINITIONS & ACRONYMS

    PK – Primary Key

    FK – Foreign Key

    N – Number (Count)

    Avg – Average

    2.2 LOGICAL SCHEME


    2.3 OBJECTS

    Data
    Table Name Field name Field Description Example
    Type
    company_tax_number PK, Identification ID of the Company 12349876 Int

    company_name name of the company ABC Group Text

    n_of_employees number of people working in this company 256 Int


    companies
    company_type Constraints: Private, Public, Multinational Private Text

    industry In what industry does the company operate Retail Text

    avg_turnover Annual average turnover (company public data) 456,076,005.08 Decimal

    platform_id PK, Surrogate Key for job searching platforms 12345 Int

    name name of the platform Jobs . GE Text


    platforms
    price_per_post Price per vacancy post in USD 7.00 Decimal
    rating of the platform - rated by users (max -
    rating 4.56 Decimal
    5.00)
    position_id FK, Surrogate Key for vacant position 98765 Int

    FK, Identification ID of the Company where the


    company_code 1234L Int
    position is vacant
    vacancies
    FK, ID of the recruiter responsible for the
    recruiter_id 45678 Int
    position
    platform_id FK, ID for job searching platforms 12345 Int

    position_id FK, Surrogate Key for vacant position 98765 Int


    Reporting
    position_name name of the vacant position Text
    Specialist
    position_details
    years_of_experience_required Years of experience required for position 2 Int

    id_required_skills FK, Surrogate Key for Skills required for position 87654 Int

    recruiter_id PK, Surrogate Key for recruiter 134 Int

    name Full Name of the recruiter Tsira Tatishvili Text

    recruiters seniority Constraints: Junior, Middle, Senior Junior Text

    recruiters are addressed to one industry: E.g.


    industry Retail Text
    Tsira is responsible for retail industry

    date_of_birth date of birth of recruiter 34733 Date

    skill_id PK, Surrogate Key for Skills 87654 Int

    skills skill Name of the skill Excel Text

    type constraint: Soft, Hard Hard Text

    skill_id FK, Surrogate Key for Skills 87654 Int

    applicant_skills applicant_id FK, ID of the Applicant 12001001234 Int

    level Constraint: Low, Middle, High High Text

    applicant_id PK, Passport ID of the Applicant 12001001234 Int


    applicants
    name Full Name of the applicant Irma Inashvili Text
    date_of_birth Date of birth of applicant 1/5/1979 Date

    experience_years Years of previous experience 3 Int

    Constraints: High School, College,


    education_level Bachelor Text
    Bachelor,Master,PHD

    email Personal Email of applicant i.inasvili@mail.ru Varchar

    telephone Personal number of telephone of applicant +995558121314 Varchar

    student_id FK, Passport ID of the Applicant 12001001234 Int

    university_id FK, ID of the University 1789 Int


    education
    years_of_study Years of study of applicant in a given university 4 Int

    degree Constraint:Bachelor, Master, pHd Bachelor Text

    university_id PK, ID of the University 1789 Int

    Rank of the university in a country (Pucliced by


    ranking 9 Int
    state education agency)

    n_of_students Average Number of students 1678 Int


    universities
    n_of_programs Number of programs university offer 12 Int

    Tbilisi State
    university_name Name of The university Text
    University
    Constraint: TRUE, FALSE - Does the university
    accreditation TRUE Boolean
    have accreditation

    You might also like