The job allocation register, Computer Engineering

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.

Posted Date: 3/18/2013 1:54:17 AM | Location : United States







Related Discussions:- The job allocation register, Assignment Help, Ask Question on The job allocation register, Get Answer, Expert's Help, The job allocation register Discussions

Write discussion on The job allocation register
Your posts are moderated
Related Questions
Many medium-to-large information services units for modern business have reorganized to be decentralized with an emphasis on dynamic teams andempowerment. In modern business system

In8085 are of the following statements is not true.A) Co-processor is interfaced in max mode. B) Co-processor is interfaced in MIN mode C )Co-processor is interfaced in max/min mod

What is an compiled languages In compiled languages the instructions into machine code and kept them  in a separate file for later implementation. Many modern compilers can com

What is the purpose of IOP. The purpose of IOP is to given an independent path way for transfer of information among external and internal memory.

Loop Level At this stage, following loop iterations are candidates for parallel execution. Though, data dependencies among subsequent iterations can restrict parallel execution

The commands (instructions) are native instructions to the 68HC11 and therefore it is termed a low level language program. Examining the program the instructions (mnemonics) they a

In 1960: The purpose of e-commerce was to exchange the electronic data. In 1970s: Electronic Fund Transfers or EFT was developed which considered as huge impact in the emerging

State about the Object models Object models are used for explaining the objects in the system and their connection with each other in the system. The dynamic model explains in

How does a computer know whether an arriving frame contains an ARP message? Explain. The type field into the frame header gives that the frame contains an ARP message. A sender

Q. Computation step in time complexity of an algorithm? So First in the computation step the local processor executes an arithmetic and logic operation. Afterwards the several