Unanswered: Inspection database design with import data from excel
I am working on design a quality control database for my company. The current database has two main tables and zero relationships. Very poorly designed. My first big hurdle is try to determine the best way to update the employee table. We recieve two excel spreadsheets every month for our employees. One is for contractors and the other for permanant employees. So far, I have the two spreadsheets linked to the database have have run a union query to combine them. Am I on the right track as far as the most efficient design? I will need to update both lists on a monthly basis. From there, I have a table for the inspectors and a table for the inspections. Each inspection includes the following information:
Routine or Annual (Not sure how to break this down. We are required a certain number of inspections a month and then required to do a seperate annual inspection on each department.
EvaluatorID (will be linked to the Evaluator table)
Reference (we use this input the requirement that we cite in the inspection)
Supervisor (the rosters I recieve to not ID anyone as a supervisor)
Weekend (this is a 'yes/no' to id whether the inspection was conducted on the weekend.)
-Equipment type (if necessary)
I am trying to determine the best way to normalize all this data as a large part of it is very redundant. Any input would be greatly appreciated.