changed SQL; added transaction and batch insert statements
moves excessive logic from controller to service; refactored api, moved sql to database.js
Denormalized unneccessary relations
added IE html5 support