REQUIRED: Develop an entity-relationship diagram of the information ssystem that supports the hiring process of Proware Company described below. Include cardinality and participation constraints.
When a manager needs to hire an employee, he or she first completes an Employee Requistion form over the company intranet, which indicates the position open, the rate of pay, hours, skills needed, and whether the requisition is for a replacement or additional employee.
Once submitted, Human Resources recruits as needed to fill the position. When applications arrive, Human Resources is responsible for prescreening the applicants. Anyone who appears suitable is scheduled for an interview with the hiring manager. The interview date and time is noted on the application, and forwarded to the hiring manager.
The hiring manager completes an interview form after each interview and attaches it to the application. When all of the interviews are complete, the hiring manager gives the name of the top candidate to Human Resources, who prepares an offer letter to be sent to the applicant. The applicant signs the letter to indicate acceptance and returns it to Human Resources. An employee file for the newest member of Proware is created, and the original application, the interview form, and the offer letter are included in it.