Devonport Royal Dockyard

Our client is a subsidiary of a major defence contractor supplying engineering services to the Submarine Flotilla of the Royal Navy. One of their tasks is to review the maintenance instructions for one class of submarines and make recommendations for changes in those instructions to the Ministry of Defence (MoD). They required an application that contained all of the maintenance instructions for all submarines. The users had to be able to create a review for an instruction and enter revised instructions together with their rationale for the revision. These proposals then had to be submitted to the MoD desk officer via Email. There were also requirements for a range of reports.

We implemented the solution as a Visual Basic program with the data stored in the company's ORACLE database. We accessed the data using Microsoft Active Data Objects (ADO) using PL/SQL packages which we wrote and installed on the ORACLE server. The reporting requirements were satisfied by automating Crystal Reports within the Visual Basic Client.