One capture screen and 2 querys. Mysql database (I provide)
$30-50 USD
Completed
Posted over 13 years ago
$30-50 USD
Paid on delivery
[M][1]ake one capture screen in any language for 7 data on al Mysql database and provide 2 querys.
## Deliverables
Tables bitacora and round have to be captures by the user
On bitacora register correspond to multiple round registers
User have to capure "have to appear in screen like this"
"Autobus:" (bus)
"ruta" (route)
And then several registers with:
"hora de salida" (departure_time) Users enter an integer number
"fecha" (date)
"ticket estudiantes" (ticket_student)
"tickets normales" (ticket_normal)
Ticket_student from the actual register minus ticket_studend from the last register = number_student It have to be recorded in the database
Ticket_normal from the actual register minus ticket_normal from the last register = number_normal It have to be recorded in the database
Capture screen must be easy to use, with enter button to automatically jump to next register
QUERYS
1. Number of passengers (students, normal or both) on average between to hours (including the hours) on a route
2. Number of passengers (students, normal or both) on average between to hours (including the hours) on a route on a concrete month (month is Januart, February, etc can be selected as 1, 2, 3)
3. Number of passengers (students, normal or both) on average between to hours (including the hours) on a route on a day of the week (day is Monday, Tuesday, etc can be selected as 1, 2, 3)
4. Number of passengers (students, normal or both) on average between to hours (including the hours) on a route on a day of the week on a concrete month
DATABASE:
I provide database, please check is usefull. There is also a average table, if you need to use it to make more easily the querys.
NOTE: I include, grafic with the tables, mysql workdbench project and create statement of the database