iPad (offline and synch capability) and web ticket application

Application is a ticket application for performing a vehicle check. Example: A person uses a checklist and performs a check of items. Check that seat belts are working, check the tires for wear, note any scratches, dents, etc and record those results using an iOS device (Android is optional right now but to make it platform agnostic is desired) such as an iPad which then uploads it to the server via a wi-fi/cell connection. This same checklist can also be captured using a paper form today so the same functionality should be replicated in a web/online version so someone can take their paper form and enter it online via a web page. Desired features of the mobile application: * Local database should allow storage of names of people and perform a simple authentication locally to use the application (last 4 digits of the SSN for instance) * Local database should allow storage of addresses or locations (address and GPS coordinates) - this will populate a location drop down list OR let the device use GPS and offer the closest location based on proximity to the stored addresses in the database. * Device should allow the application to work offline and save those tickets on the device. - Once the device regains connectivity (cell or wi-fi), the application will automatically synchronize the tickets to the server. * Use native mobile functionality to take advantage of those features (swipe to refresh, hold/pause to prompt options, etc.) * Receive application updates and database changes (deletes, adds, changes) from the application server. * Application should acknowledge if there's a new version out there once it auto connects - first it should upload any tickets from the device then upgrade the application. * Enforce required fields * Allow Inspection type drive what fields are shown in the form (show different or hide selections below) Desired features of the Web entry page: * Mobile device and Web entry page should be identical. Web entry page should allow some additional error checking and/or filtering capabilities. * Can perform a print and data fill using a formatted form (so it looks like the preprinted paper forms they use today for the checklist). * Enforce required fields Desired features of an admin interface/application server: * Can send application upgrades to the devices (push to existing) * Can send application to new devices (via an email link/SMS?) * Forms can be edited and selections changed (and are sent out in the next application upgrade) * New sections can be added (if I wanted to add another section with checkboxes for instance) * Sections can be reordered (i can move the inspection type section above weather for instance) * Selections (check boxes) appear in the order they are entered * Tickets in database can be exported to CSV/XLS * Allows an excel upload into the database using an XLS template * Set on/off for required fields * Nice to have: Set how checkboxes are displayed on screen (example: 3 columns of 2, 1 column of 6, etc) Database design * Sites - should contain site name, address, GPS location. * Customers - should have names. Customers need to be linked to one site or multiple sites. * Inspection location - set of specified locations (parking lot, garage, repair bay, etc); no link needed to other tables. * Inspector name - name, SSN or employee ID, supervisor's employee ID