Database design and few SQL squeries

In Progress Posted Feb 8, 2014 Paid on delivery

$30-250 USD

Paid on delivery

In Progress Paid on delivery

I am designing guard patrol system. Watchmen walks around the building and checks his presence on different locations where "Sensors" are. The tour is predefined in system with order of locations (sensors), time (in minutes) between two sensors and time tolerance (between sensor1 and sensor2 it is expected that watchman will need 5 minutes and +-2 minutes tolerance.

I need help with database design and SQL queries which will show planned and real path and marked all deviations.

More info in attached doc.

Specification: http://j.mp/1eBlaOy

MySQL Software Architecture SQL

Project ID: #5410074

About the project

16 proposals Remote project Active Feb 10, 2014

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Post a project like this