Question: Please answer this question 4:31 PM Mon Feb 3 32%O Done Assignment22 Temporary Employment Corporation (TEC) places temporary workers in companies during peak periods. TEC's

 Please answer this question 4:31 PM Mon Feb 3 32%O Done

Please answer this question

4:31 PM Mon Feb 3 32%O Done Assignment22 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. If the candidate has worked before that candidate has a specific job history. Each candidate has several qualifications. 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. The folder contains an opening number, company name, required qualifications, starting date, anticipated ending date, and hourly pay. Each opening requires only one specific or main qualification, When a candidate matches the qualification, (she is given the job, and an entry is made in the Placement Record folder. This folder contains an opening number, candidate number, total hours worked, and so on. In addition, an entry is made in the job history for the candidate. TEC uses special codes to describe a candidate's qualification for an opening. The list of codes include: CODE DESCRIPTION SEC-45 Secretarial work at least 45 words per minute SEC-60 Secretarial work at least 60 words per minute CLERK General clerical work PRG-VB Programmer, Visual Basic PRG-C++ Programmer, C++ DBA-ORA Database Administrator, Oracle DBA-DB2 Database Administrator, DB2 SYS-1 Systems Analyst, level 1 SYS-2 Systems Analyst, level 2 NW-NOV INetwork Administrator, Novell experience Identify all Entities, Attributes, including key attributes, Relationships and complete the following tasks. 1. Draw the E-R diagram for this enterprise. 2. Identify all possible relationships 3. Identify the Cardinality Ratio for each relationship. 4. Indicate Participation Constraint 5. Indicate Min/Max constraint. 4:31 PM Mon Feb 3 32%O Done Assignment22 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. If the candidate has worked before that candidate has a specific job history. Each candidate has several qualifications. 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. The folder contains an opening number, company name, required qualifications, starting date, anticipated ending date, and hourly pay. Each opening requires only one specific or main qualification, When a candidate matches the qualification, (she is given the job, and an entry is made in the Placement Record folder. This folder contains an opening number, candidate number, total hours worked, and so on. In addition, an entry is made in the job history for the candidate. TEC uses special codes to describe a candidate's qualification for an opening. The list of codes include: CODE DESCRIPTION SEC-45 Secretarial work at least 45 words per minute SEC-60 Secretarial work at least 60 words per minute CLERK General clerical work PRG-VB Programmer, Visual Basic PRG-C++ Programmer, C++ DBA-ORA Database Administrator, Oracle DBA-DB2 Database Administrator, DB2 SYS-1 Systems Analyst, level 1 SYS-2 Systems Analyst, level 2 NW-NOV INetwork Administrator, Novell experience Identify all Entities, Attributes, including key attributes, Relationships and complete the following tasks. 1. Draw the E-R diagram for this enterprise. 2. Identify all possible relationships 3. Identify the Cardinality Ratio for each relationship. 4. Indicate Participation Constraint 5. Indicate Min/Max constraint

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!