The job allocation register, Computer Engineering

Assignment Help:

Signify this problem by means of:
i.    An Entity Relationship model;
ii.    Relational tables.
Pete's Programmers is a firm which supplies part time staff on contract to organisations requiring computing experts for short periods of time.  He keeps a file on all contractors which haves their contractor-id, name and phone.
Clients ring Pete to discuss their requirements. If it is a new client, he records their name, phone number, address and assigns them a client-id.

Pete then assigns a unique job number to every request, notes the request date and the needed start-date. He then determines which skills will be needed (e.g. AN = analysis, SQ = SQL coding, DD = database design etc.) and estimates the number of days needed to complete the job. He next consults a card catalogue to determine the potential contractors having all the skills needed for the job.

Finally Pete looks in the job allocation register, that shows when each contractor is expected to start and when they actually finish working on a particular job.  Therefore he can determine which have free time. Contractors can be assigned to tasks either full time or part time, so it is possible for a contractor to be working on many jobs at the same time. Pete assigns one or more contractors to the job. The job contract is then completed, and after signing by the customer, Pete files a copy.
As the contractors work on the job, they are needed to file a daily work sheet that shows how many hours they have worked on any job. When every job is finished, the contractor notifies Pete so his records can change the status of the job and the client can be billed. Note that the job status can either be R = requested, O = ongoing, S = suspended or C = completed.)
Note that your solution needs to be flexible so that:

-    contractors can be replaced whereas working on jobs;

-    contractors can be started or terminated at any time for any job.


Related Discussions:- The job allocation register

Determine the o/p for JK flip flop with J=1 & K=0, For JK flip flop with J=...

For JK flip flop with J=1, K=0, the output after clock pulse will be ? Ans. The output will be 1 after clock pulse.

Explain naming convention scripts, Explanation:- A script within Rationa...

Explanation:- A script within Rational Robot is a file that haves a sequence of SQABasic code. The extension of the file is always ".REC". Syntax [FEATURE] + "_" + [FUNCTION

what is a persistent cookie in php, A persistent cookie is a cookie which ...

A persistent cookie is a cookie which is keeps in a cookie file permanently on the browser's computer. By default, cookies are formed as temporary cookies which keep only in the br

Information system for strategic advantage, Q. Describe short note on Infor...

Q. Describe short note on Information system for strategic advantage? Ans. Strategic role of information systems engage using information technology to develop products or serv

4 variable k-maps, 4-variable K-maps have 16 squares which arearranged in 4...

4-variable K-maps have 16 squares which arearranged in 4 columns and 4 rows.  Columns and rows are labeled with 2 variables. The rows are arranged so that C or D ch

What are latches and flipflops, What are latches and flipflops? There a...

What are latches and flipflops? There are two types of circuits as follows: a. Combinational b. Sequential Flipflops and latches both come into the category of "sequen

What is typical storage hierarchy, Q. What is typical storage hierarchy? ...

Q. What is typical storage hierarchy? A typical storage hierarchy is displayed in Figure above. Though Figure shows only block diagram however it includes storage hierarchy:

Explain about different types of mice, Q. Explain about different types of ...

Q. Explain about different types of Mice? Mice can be classified on the foundation of numbers of buttons, position sensing technology or type of Interface:  Sensing Technol

What are the advantages of open source system, What are the advantages of o...

What are the advantages of open source system? High-quality software Lesser hardware costs Integrated management No vendor lock-in Take control of our softwa

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd