Question: For each problem below, create a clear ERD showing the relationships (with verb like HAS, MANAGES, etc.), the cardinalities (1:1, 1:M, M:N), and whether the

For each problem below, create a clear ERD showing the relationships (with verb like HAS, MANAGES, etc.), the cardinalities (1:1, 1:M, M:N), and whether the relation is optional or required. For M:N relations, include an appropriate linking table to implement them. Entities should have necessary attributes shown, as can be discerned from the description.

2. During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC's manager gives you the following description of the business: TEC has a file of candidates who are willing to work. If the candidate has worked before, that candidate has a specific job history . (Naturally, no job history exists if the candidate has never worked for TEC.) Each time the candidate works, one additional job history record is 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 BSCS degree or a Microsof t Network Certification. And clearly, a candidate may have earned both a BSCS and a Microsoft Network Certification.) Many such qualifications are possible, and the number may change over time. TEC also has a list of companies that request temporaries. 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, an anticipated ending date, and hourly pay. Each opening requires only one specific or main qualification. 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. TEC uses special codes to describe a candidate's qualifications for an opening. A list of codes includes a short code (e.g., MNC) and a description (e.g., Microsof t Network Certification) TEC's management wants to keep track of the following entities: COMPANY OPENING QUALIFICATION CANDIDATE JOB_HISTORY PLACEMENT Given that information, create the complete ERD.

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!