Question: *very strict grading method. Please help me excel in this. Question 2 (11 pts) Draw an EER diagram for the following problem. Make sure all

*very strict grading method. Please help me excel in this.
Question 2 (11 pts) Draw an EER diagram for the following problem. Make sure all cardinalities are represented. If the information provided are not enough, state any assumptions that you have made while drawing your diagram. A company posts job opening online. Job seekers must apply for these jobs online as well. The company has a strict policy that only one job application is allowed for each job seeker. Job openings usually have several applicants, but it is possible for some opening to have no applicant. Only job seekers who applied for a job opening are saved in the database. Job seekers have an ID, name, address, work history and qualifications. A job posting can only be either for a part-time or full-time position and those two position types are distinct from each other. Part-time positions have a total number of weekly hours and an hourly rate. Full-time positions have a monthly salary. Both types of job listings have details about the position title, and experience required as well as a unique job opening ID. For some, but not all, of the full-time job openings, the company ask recruiting agencies to take care of the hiring and interview process. The company works with several recruiting agencies, and keep information about the agency name, contact person name and phone number, in addition to an assigned agency identification number. While a recruiting agency must be in charge of several full-time job openings, each full-time job opening can only be assigned to one agency until the position is filled
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
