Database Answers Robert Blake, Electra Glide in Blue, 1973

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Contract Staff Agencies
   Back to the Data Model.

The Draft Business Rules have been defined and are listed below.
The Area being Modelled is Contract Staff Agencies

The Specifications have been produced by Ted in the following terms :-

Pete’s Programmers is a firm which supplies part time staff on Contract to Client organisations needing computing experts for short periods of time. 
He keeps a file on all Contractors which contains 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 each Request, notes the request date and the required start-date. 

He then determines which Skills will be required (e.g. AN = analysis, SQ = SQL coding, DD = database design etc.) 
and estimates the number of days required to complete the job. 
He next consults a card catalogue to determine the potential contractors having all the skills required 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. 

Thus 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 required to file a daily work sheet that shows how many hours they have worked 
on any job. 

When each 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.) 

A.1 There are no Notes for this Design.

B. The Things of Interest, ('THINGS'), include :-
B.1 Agencies
B.2 Agents
B.3 Contracts 
B.3 Contractors (Staff)
B.4 Others to be determined

C. These THINGS are Related as follows :-
C.1 An AGENT can deal with zero, one or many CONTRACTORS.

D. Other Characteristics of these THINGS include :-
D.1 To be determined

E. Sample Data includes :-
E.1 To be determined

F. Typical Enquiries include :-
F.1 To be Determined

Barry Williams
September 9th.  2009
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map