This ER (Entity Relationship) Diagram represents the model of Resume Builder Entity. The entity-relationship diagram of Resume Builder shows all the visual instrument of database tables and the relations between Skills, Question, Resume, Salary etc. It used structure data and to define the relationships between structured data groups of Resume Builder functionalities. The main entities of the Resume Builder are Resume, Skills, Job, Question, Jobseeker and Salary.
Resume Builder entities and their attributes :
- Resume Entity : Attributes of Resume are resume_id, resume_user_id, resume_name, resume_type, resume_description
- Skills Entity : Attributes of Skills are skill_id, skill_user_id, skill_name, skill_type, skill_description
- Job Entity : Attributes of Job are job_id, job_name, job_type, job_salary, job_vacancy, job_description
- Question Entity : Attributes of Question are question_id, question_title, question_type, question_description
- Jobseeker Entity : Attributes of Jobseeker are job_seeker__id, job_seeker__name, job_seeker__mobile, job_seeker__email, job_seeker__username, job_seeker__password, job_seeker__address
- Salary Entity : Attributes of Salary are salary_id, salary_employee_id, salary_amount, salary_total, salary_type, salary_description
Description of Resume Builder Database :
- The details of Resume is store into the Resume tables respective with all tables
- Each entity ( Salary, Job, Jobseeker, Skills, Resume) contains primary key and unique keys.
- The entity Job, Jobseeker has binded with Resume, Skills entities with foreign key
- There is one-to-one and one-to-many relationships available between Jobseeker, Question, Salary, Resume
- All the entities Resume, Jobseeker, Job, Salary are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Resume Builder tables for fast query execution.