I attempting to create simple DB for a Service repairs.
The idea is that customers would bring in equipment for repairs. The quipement gets registered for repairs and then is sent of to repairers to be fixed. There a several repairs according to what needs to be fixed and these repairer may use more than one contact details.
Should I have separate table for Customer No and Repairer No. So that user can select which one the want. Should I base the Primary Key using the CustNumber and RepNumber.
Any help to ensure that Im on the right track would be appreciate because I want make sure that I have things normalised now before start on any fancy stuff.
I was think along these lines:
CustNumber (eg C0001) searches are based on this No.