I wonder if anyone is able to give me any suggestions regarding the structure of a database I wish to create.
The database concerns the management and recording of engineering tasks on items of machinery.
Simplified significantly.
- There will be a number of identical but unique machines.
- Each machine will be subject to a schedule of service events.
- There will be several different types of service event
- Each service event will consist of a number of tasks.
- Some tasks will be unique to a particular service, others will associate with various different services.
I require the user to be able to add service events to a given machine, to be able to log when tasks associated with a service have been completed and to be able to query which tasks for a given service are outstanding.
I've tried a few approaches but I think I may be over complicating things, this must be a fairly common database problem.
All help gratefully received