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

How do you make an image clickable in HTML, How do you make an image clicka...

How do you make an image clickable in HTML? Give an example. To create an image or text clickable hyperlinks are used, that use the and tags. Such tag has different paramet

Dram, DRAM consists of MOSFET's but the technique is to use the drain sourc...

DRAM consists of MOSFET's but the technique is to use the drain source capacitance to hold charge. If charge is present logic '1' is held, no charge logic '0'. As you know capacito

What is the demand of mobile application developers, Desktop based IT appli...

Desktop based IT application is present but the mobile is future. All the applications that were made to work only on counter top are being ported to mobile. In the coming 10 years

Catch output from child tasks, Q. Catch output from child tasks? ...

Q. Catch output from child tasks? int pvm_catchout( FILE *ff ) Catch output from child tasks. ff is file descriptor on which we write collected output. The defau

What is the relation between response time and throughput, The Throughput g...

The Throughput graph represents the amount of data in bytes that the Vusers received from the server in a second. When we evaluate this with the transaction response time, we will

Discuss functioning of different network access equipments, Discuss the fun...

Discuss the functioning of different network access equipments. The E1 multiplexers MX2000 and MX2411 and E1/T1 MX200 are giving multi interface user access to network PDH or S

Illustrate the ftp commands, Q. Illustrate the FTP commands? FTP includ...

Q. Illustrate the FTP commands? FTP includes many commands however only few are used to retrieve a file. A user is required to understand the three basic commands to connect to

Explain the importance of computer architecture, Explain the importance of ...

Explain the importance of computer architecture Studying the architecture implies working on machine language programs. However, this isn't practical when we design a computer

Explain the fetch cycle, Q. Explain the Fetch Cycle? The beginning of e...

Q. Explain the Fetch Cycle? The beginning of every instruction cycle is the fetch cycle and causes an instruction tobe fetched from memory.   The fetch cycle comprises four

Define parity generator, Define parity generator During transmission, a...

Define parity generator During transmission, at sending end the message is applied to a parity generator, where the needed bit is formed.

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