I have been given a task at work to change an excel spreadsheet that our fleet department use into a db driven website.
The idea is that it will cut down on our need for Excel at each branch and allow us to create some reports based on the spreadsheet.
Now my problem is that I cant think how to structure the db best.
I have uploaded a copy of the sheet here so you can take a look (http://www.techmonkeys.co.uk/KiD/files/checksheet.xls) and see what you think.
The way it is used is that each branch will fill in their vehicle reg's and dates that they entered the state (staff usage/accident damage/in service, etc) and once they have completed it, they will then email a copy to the fleet department.
We want them to go to a webpage fill in the details and click done, then the fleet dept will be able to view the sheets online, print them off or run some reports on the data.
Can anyone help me with the db structure? I will be doing it in php and mysql.
The idea is that it will cut down on our need for Excel at each branch and allow us to create some reports based on the spreadsheet.
Now my problem is that I cant think how to structure the db best.
I have uploaded a copy of the sheet here so you can take a look (http://www.techmonkeys.co.uk/KiD/files/checksheet.xls) and see what you think.
The way it is used is that each branch will fill in their vehicle reg's and dates that they entered the state (staff usage/accident damage/in service, etc) and once they have completed it, they will then email a copy to the fleet department.
We want them to go to a webpage fill in the details and click done, then the fleet dept will be able to view the sheets online, print them off or run some reports on the data.
Can anyone help me with the db structure? I will be doing it in php and mysql.
