Hi im working on a project where creating a database
Its regarding a car mechanic company who go out and repair broken down or cars what have been in an accident.
Anyway the main target behind it is once iv created the database, i want to be able to be able to use data mining tools to find 2 ways of analysing two different parts of the business.
For example. For every job 2 technicians get sent out. Each technician varies on level of skill/qualification.
So some sort of SQL to show how the level of job efficiency is affected by what technicians are paired together..
Efficiency being judged by how long they take to repair (arrival time on the scene to leaving time)
The above sounds so brief, but hopefully someone will understand what i mean. Just looking for an outside perspective.