A Boston-based firm called Course Hero is seeking candidates for a number of positions that have become
Fantastic news! We've Found the answer you've been seeking!
Question:
Develop an ER model based on the information outlined below.
Here are the details Solution's management team has shared with some data modelers:
Job applicants can apply for multiple positions, while Solution has several open positions. During the initial process of applying for a job, an applicant may initiate contact with one recruiter, while recruiters can talk to several applicants about the position. Once a job applicant is short-listed for an interview, he/she must be categorized as 'Candidate' in Solution's database system. To know more details about the position and compensation, a candidate must interact with a recruiter while recruiters can talk to all short-listed candidates before their interviews. A Candidate has to go through multiple rounds of interview, while each interview round can include multiple candidates (at different times slots). Course Hero designates hiring managers, who participate in several interviews, while an interview must be attended by several hiring managers (as interviewers). After the interviews are concluded, hiring managers (that participated in the interview process) must recommend at least two candidates for hire (and rank order them), while a candidate must be recommended by more than one hiring manager to be considered for hire.
Note: Include 2-3 attributes (in addition to the PK and FK) for each of the entities in your ER Model. Further, include at least one attribute (in addition to the two FKs/composite PK) for each bridge/junction table that you include in your ER Model.
Related Book For
Contemporary Auditing real issues and cases
ISBN: 978-1133187899
9th edition
Authors: Michael C. Knapp
Posted Date: