Question: Please help me create a ERD diagram for the sql question below. Thanks The Atlantic Employment Corporation (AEC) provides a wide variety of jobs for
Please help me create a ERD diagram for the sql question below. Thanks
The Atlantic Employment Corporation (AEC) provides a wide variety of jobs for temporary workers in companies during peak periods (such as Christmas season). AEC would like you and your team to design database that will manage the business operations. The requirements of data to be modelled are listed below and AEC's management wants to be able to: Track information about the candidates who are willing to work includes their numbers, names, SSN, phone number, email, home address (# number, city, province, and postal code). If the candidate has worked before, that candidate has a specific job history. Each time the candidate works, one additional job history record is created. There is no job history exists if the candidate has never worked. Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. AEC has a list of companies that request temporary employees. AEC keeps basic contact information for each company (company name, address info, phone, and contact person). Each company has made at least one request for a temporary employee. Each time a company requests a temporary employee, AEC makes an entry in the Openings folder. That folder contains an opening number, a company name requesting
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
