I have been asked to create a database for site visits. The checks for the visits will be the criteria
below. (I left out the target number values for the items.)
The numbered items are just section headings.
The answers for all the lettered items will be Yes/No
There are a fixed number of sites but they will have multiple visits.
My question is should I create 1 Site table and then a large table with all the lettered(30) questions and join them.
or Create 1 site table and a table for each numbered section and join them somehow
with a one -to-many or many-to-many.
Your input is appreciated.
Site Visit Checklist
Site:
Date:
1. Site Performance Status Report
a. Response Time:
b. Call Back:
c. Customer Assistance:
d. First Time Fix:
e. Calls per tech:
f. Labor Hours:
g. MA %:
h. Parts Cost per Call
i. Machines per Tech:
2. Adjusted Service P&L
a. Parts Expense:
b. Salaries:
c. Copy Expense:
d. Total Cost and Expenses:
3. Asset Management
a. Days on Hand:
b. Average Freight Cost per Shipment:
c. Inventory $ discrepancy per quarter:
4. Employee Improvement and Development
a. # of Product Training during current year
b. # of Self Pace Training during current year
c. % of CSS training completed
d. Certifications
e. Employee Performance Improvements
5. Corporate Initiatives
a. Remote
