Database Answers Skills and Authorisations
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Skills and Authorisations
 
The Area being Modelled is :-
Skills and Authorisations
This is the start of Gary's Specifications
Hi Barry
I’m looking through your library of previously constructed databases absolutely sure 
there is one there I can use! 
No luck so far I’m afraid so maybe you could suggest one that will work for me ?
I don’t know how much ‘previous’ you have so I’ll explain what I need twice! 
Once presuming you know what I’m talking about, and once presuming not.
I’m in the aviation engineering industry where all our work is authorised using personally issued stamps. 
I need to keep a track of which stamp was issued to who and when, together with the 
authorisations held and when. 
I need to be able to search by stamp, by date, and by user.
Ok. Now for the ‘lay’ decode!
When an engineer reaches a certain level of competency in a particular area,
he is issued with a rubber stamp which he then uses to indicate that he has 
done a particular task (he is said to be ‘authorised’ to carry out that task). 
The date the stamp is issued to the person needs to be tracked as does the date 
it is eventually withdrawn. 
As the level of competency of the engineer grows and/or broadens, 
more ‘authorisations’ will be added to his stamp (again, with start/end dates). 
Conversely, if the engineer does not work at a particular task for a period of time, 
he may have that particular ‘authorisation’ withdrawn (he keeps his stamp, but it no 
longer authorises him to do that job). 
So to summarise: engineer gains stamp; authorisations are added/withdrawn over time; 
engineer loses stamp.
In addition to this it is always possible that a stamp may get lost. 
In which case the whole ‘suite’ of authorisations held by the engineer need to be transferred 
(again, with a transfer date) to a new stamp. 
His authorisations don’t change, but the stamp number that signifies them does.
Stamps can also only be re-used after a period in Quarantine. 
So this is another factor which needs to be built in. 
After withdrawal a stamp may not be issued to anyone else for a period of time.
I think that about covers it! 
Do you have a ready-made database that is close enough to my requirements?
Cheers,
Gary

B. The Things of Interest, ('THINGS'), include :- B.1 To be determined. C. These THINGS are Related as follows :- C.1 To be determined. 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 March 11th. 2010 Principal Consultant Database Answers Ltd. London, England
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map