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

Explain the life cycle of java server pages, Discuss the life cycle of JSP....

Discuss the life cycle of JSP. A JSP (JavaServer Pages) page services requests like a servlet. Therefore, the life cycle and many of the abilities of JSP pages (particular in t

Applications of linked list, What are the Applications of Linked List are ...

What are the Applications of Linked List are a) Fixed block storage allocation b) garbage collection

recycling from e-waste to resources , Make at least 6 web pages with good ...

Make at least 6 web pages with good formatting, color balance and presentation on any one of the following topics:- 1.    Recycling from E-waste to resources 2.    Light and So

An 8086 interrupt, An 8086 interrupt can take placedue to the following rea...

An 8086 interrupt can take placedue to the following reasons: 1.  Hardware interrupts caused by some external hardware device. 2.  Software interrupts that can be invoked wit

Classification according to pipeline configuration, Classification accordin...

Classification according to pipeline configuration: According to the configuration of a pipeline, the following parts are recognized under this classification: Unifunct

Explain recursion, What is recursion? Recursion: - Recursion is describ...

What is recursion? Recursion: - Recursion is described as a technique of defining a set or a process in terms of itself.

Explain the types of hardware used in supermarkets, Explain the types of ha...

Explain the types of hardware used in supermarkets These use many types of specialist I/O hardware. For instance: -  Bar code readers/scanners (to read product details and e

Illustrate what is universal law of universal gravitation, Q. Illustrate wh...

Q. Illustrate what is the universal law of universal gravitation? Answer:- Declaration that any particle of matter in the universe attracts any other with a force varying

Overfitted the data, Overfitted the data: Moreover notice that as time...

Overfitted the data: Moreover notice that as time permitting it is worth giving the training algorithm the benefit of the doubt as more as possible. However that is, the error

What are the dynapro keywords, What are the dynapro keywords? FIELD, MO...

What are the dynapro keywords? FIELD, MODULE, SELECT, VALUES and CHAIN are the dynapro keywords

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