Provide an ER diagram representing the above requirements. You may hand-draw the ER diagram if you wish and map this diagram to a relational model using the compact form where we underline primary keys and circle, or place in bold italics, foreign keys.
Part II: The Just-in-Time Temporary Employee Registry (JITTER) recommends temporary employees to a company during peak periods for the company. JITTER's manager provides the following description of how the business maintains its records.
1. JITTER maintains a file of candidates who are willing to work. Each new candidate is given a unique ID number. The company also maintains the candidate's name, address, SSN, and an email address.
2. JITTER maintains a list of companies who have, or are interested in, temporary employees. Each company has a unique ID number. JITTER also records the company name, a contact person within the company, and an email address for the contact person.
3. If a candidate has found work through JITTER before, that candidate will have a specific job history.
4. Each candidate has several qualifications. The qualifications use special codes and a description. Examples of such codes and descriptions are:
- ADA-L1: Administrative Assistant - Level 1
- ADA-L2: Administrative Assistant - Level 2
- PGR-PHP: Programmer - PHP proficient
- PGR-C++: Programmer - C++ proficient
- DBA-SQS: Database administrator - SQLServer
- SYS-UNX: System Administration - Unix
- NET-CIS: Network Administrator - Cisco experience
5. Each time a company requests a temporary worker, JITTER makes an entry in an "Openings" folder. The folder contains an opening number that is unique per opening, the company ID, a qualification, a starting date, an anticipated ending date, and an hourly pay rate. The opening must indicate a qualification.
6. When a candidate matches a qualification sought, that candidate is given the job and an entry is made in the Placement Record folder. The folder contains an opening number, candidate number, total hours worked, and so on. In addition, an entry is made in the job history for the candidate.
7. JITTER uses special codes to indicate.
