Temporary Employment Corporation (TEC) places temporary workers in companies during peak periods. TEC’s manager gives you the following description of the business: TEC has a file of candidates who are willing to work. The file contains candidate id, full name, address, email (if any) and telephone number. 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 an Oracle 4 Database Certification. And clearly, a candidate may have earned both a BBA and an Oracle Database Certification. Each qualification has a qualification code and name using special codes (eg: BBA: BBA degree, DBA-ORA: Oracle Database Certification). TEC has a list of companies that request temporaries. The attributes are company id, name, address, email address and telephone number. Each time a company requests a temporary employee, TEC makes an entry into the job openings folder. This folder contains a job opening number, company id, qualification code, starting date, anticipated ending date, hourly pay and number of candidate needed. Each job opening requires only one specific or main qualification. When a candidate matches the qualification, (s)he is given the job and an entry is made in the job placement record folder. The folder contains an opening number, candidate id, total hours worked, and so on. A job opening can be filled by many candidates and a candidate can fill many job openings. You need to provide an ERD and data dictionary that define the database.
Temporary Employment Corporation (TEC) places temporary workers in
companies during peak periods. TEC’s manager gives you the following
description of the business:
TEC has a file of candidates who are willing to work. The file contains
candidate id, full name, address, email (if any) and telephone number.
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 an Oracle 4
a BBA and an Oracle Database Certification. Each qualification has a
qualification code and name using special codes (eg: BBA: BBA degree,
DBA-ORA: Oracle Database Certification).
TEC has a list of companies that request temporaries. The attributes are
company id, name, address, email address and telephone number.
Each time a company requests a temporary employee, TEC makes an
entry into the job openings folder. This folder contains a job opening
number, company id, qualification code, starting date, anticipated
ending date, hourly pay and number of candidate needed.
Each job opening requires only one specific or main qualification.
When a candidate matches the qualification, (s)he is given the job and
an entry is made in the job placement record folder. The folder contains
an opening number, candidate id, total hours worked, and so on.
A job opening can be filled by many candidates and a candidate can fill
many job openings.
You need to provide an ERD and data dictionary that define the database.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
