Question: Design an EER diagram Construct an EER model for a database for a recruitment company. This database keeps information of persons who want to find

Design an EER diagram

Design an EER diagram Construct an EER model for

Construct an EER model for a database for a recruitment company. This database keeps information of persons who want to find a job, as well as information of companies that are finding some qualified employment candidates. Some detail requirements are given below. Note that the EER model needs to include the primary key for each entity as well as multiplicity (cardinality and participation) for each relationship. (16 marks) The model stores the personal information of a job seeker (a person who is finding a job). The model stores the company profile of a company which is finding some personnel. A company can post a set of jobs it provides. A job seeker can post a set of skills he/she has. There are three types of jobs: part-time jobs, full-time jobs and project-based jobs. Each job type may have different information. For example, a part time job has wage information, a full-time job has salary and other benefit information and a project-based job has project duration (period). Jobs are organized into categories, e.g. 'Computer', 'Construction', 'Food', 'Art' and so on. A job seeker can apply for a job that a company posted. A company can ask a job seeker who has a skill that the company requires. Each job can be assigned to only one job seeker. It is possible to list the names of jobs and their contact person. It is possible to list the names of skills and the job seekers who have those skills

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!