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 

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!