For the business rules given below, create a fully labeled Crow’s Foot diagram using Visio. Business rules are as follows: 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 and a list of companies that request temporaries. If the candidate has worked before, that candidate has a specific job history. Each time the candidate worked; one additional job history record was created. Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. 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, (s)he is given the job 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 filed by many candidates, and a candidate can fill many openings.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

For the business rules given below, create a fully labeled Crow’s Foot diagram using Visio. Business rules are as follows:

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 and a list of companies that request temporaries.
If the candidate has worked before, that candidate has a specific job history. Each time the candidate worked; one additional job history record was created.
Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate.
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, (s)he is given the job 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 filed by many candidates, and a candidate can fill many openings.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions