Corporate Recruitment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Corporate Recruitment System Entity. The entity-relationship diagram of Corporate Recruitment System shows all the visual instrument of database tables and the relations between Job Provider, Experience, Company, Job etc. It used structure data and to define the relationships between structured data groups of Corporate Recruitment System functionalities. The main entities of the Corporate Recruitment System are Company, Job Provider, Job Seeker, Experience, Technology and Job.

Corporate Recruitment System entities and their attributes :

• Company Entity : Attributes of Company are company_id, company_name, comapny_type, company_description, company_address
• Job Provider Entity : Attributes of Job Provider are job_provider__id, job_provider__name, job_provider__mobile, job_provider__email, job_provider__username, job_provider__password, job_provider__address
• Job Seeker Entity : Attributes of Job Seeker are job_seeker__id, job_seeker__name, job_seeker__mobile, job_seeker__email, job_seeker__username, job_seeker__password, job_seeker__address
• Experience Entity : Attributes of Experience are experience_id, experience_employee_id, experience_year, experience_type, experience_description
• Technology Entity : Attributes of Technology are technology_id, technology_name, technology_type, technology_description
• Job Entity : Attributes of Job are job_id, job_name, job_type, job_salary, job_vacancy, job_description

Description of Corporate Recruitment System Database :

• The details of Company is store into the Company tables respective with all tables
• Each entity (Job, Job Seeker, Technology, Job Provider, Company) contains primary key and unique keys.
• The entity Job Seeker, Technology has binded with Company, Job Provider entities with foreign key
• There is one-to-one and one-to-many relationships available between Technology, Experience, Job, Company
• All the entities Company, Technology, Job Seeker, Job are normalized and reduce duplicacy of records
• We have implemented indexing on each tables of Corporate Recruitment System tables for fast query execution.