(Solved): ***** This is a Chen Notation ER Diagramming Assignment. Only Chen Notation Diagrams will be accep ...

***** This is a Chen Notation ER Diagramming Assignment. Only Chen Notation Diagrams will be accepted. ***** During peak periods, the Temporary Employment Corporation (TEC) places temporary workers in companies. TEC's manager gives you the following description and business rules of the business: • TEC has a file of candidates who are willing to work. They would like to put this Candidate File Information into a Database. • If the candidate has worked before, that candidate has a specific job history. (Naturally, no job history exists if the candidate has never worked.) Each time the candidate works temporarily for an outside company, one additional job history record is created. TEC wants the candidate's Job History in a database. • Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. (For example, it is possible for more than one candidate to have earned a BBA degree or a Microsoft Network Certification. And clearly, a candidate may have earned both a BBA and a Microsoft Network Certification.) TEC wants to store all existing and future types of Qualifications in a database. • TEC offers courses to help candidates improve their qualifications. This is done by offering training courses so that candidates can earn qualifications. TEC wants to keep store all courses that they offer for qualifications in a Database • Every course develops one specific qualification; however, TEC does not offer a course for every qualification. Some qualifications have multiple courses that develop that qualification. • Some courses cover advanced topics that require specific qualifications as prerequisites. Some courses cover basic topics that do not require any prerequisite qualifications. A course can have several prerequisites. A qualification can be a prerequisite for more than one course. • TEC also has a list of companies that request temporary employees. • Each time a company requests a temporary employee, TEC makes an entry in the Openings folder. That folder contains an opening number, a company name, required qualifications, a starting date, and anticipated ending date, and hourly pay. TEC wants to store all company requests for temporary jobs in a database. • When a candidate matches the qualification, the job is assigned, and an entry is made in the Placement Record folder. That folder contains an opening number, a candidate number, the total hours worked, etc. In addition, an entry is made in the job history for the candidate. • An opening can be filled by many candidates, and a candidate can fill many openings. Summary Information that has to be Maintained • Client Company Information. These are companies that need Temporary Workers. • Job Opening Information, a Company offers one or more Temporary Job-Opening Positions Qualification or Skills of the Candidates in (TEC). A Candidate can have one or more Qualifications Candidate or Temporary Worker Information. A Candidate is a Temporary Worker seeking a position • Candidate JOB_HISTORY Information. This is a Temporary Workers Work History. • Placement Information. This is the Record of all Temporary Workers Placed in a Temporary Job • Training Courses that are being offered to (TEC) Candidates. • Training Courses that Candidates have taken Given that information, do the following: 1. Draw the Chen ERDs for this enterprise 2. Identify all Entities 3. Identify all Attributes for the Entities 4. Identify all possible relationships 5. Identify the Cardinality for each relationship 6. Resolve all 1: N relationships 7. Resolve all M: N relationships 8. Identify Primary Keys and map the Foreign Keys based on the described Cardinality