Question: Use the following information to answer the question Create an ERD based on the Crow's Foot model, with the following information: During peak periods, Temporary
Use the following information to answer the question

Create an ERD based on the Crow's Foot model, with the following information: During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC's manager gives you the following description of the business: TEC keeps track of candidates who are willing to work. TEC stores the candidate's name, address, and phone number. If a candidate has worked before, that candidate has a specific job history that keeps track of the start date and end date of a job. No ob history exists if the candidate has never worked. Each time the candidate worked, one additional job history record was created. 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. A single candidate may have earned both a BBA and a Microsoft Network Certification .TEC also keeps track of companies that request temporary employees. TEC will store the company name and contact information. Each time a company requests a temporary employee, TEC records an Job Opening entry that contains an opening number, company name, required qualification, starting date, anticipated end date, and hourly pay. Each opening requires only one qualification. An opening can be filled by only one candidate, but a candidate can fill many openings
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
