Taxi Booking System


1. Customer registration: create a new registered customer (with name, location, contact, payment information, username and password)

2. Enter information of a shift: enter car, driver, start time, end time of shift.

3. A customer reserves a car. The customer needs to provide username, password, pickup time, pick up location and zip, destination location and zip, #of passengers. The system needs to estimate the driving time (based on zones), and assign a driver who is working during that time and is available. The availability is determined by the following conditions:

1) the reservation is made at least 60 minutes before the pickup time.

2) the driver works in a shift that covers the duration of the trip (i.e., starttime of shift <= pickup time and endtime of shift >= estimated drop off time)

3) the driver has no reservation within 30 minutes before or after the duration of the current reservation (more specifically, you need to exclude 3 cases: a) there is a reservation whose pickup time falls in the range of [current_pickup_time-30 min, current_dropoff_time+30 min]); b) there is a reservation whose drop off time falls in the range of [current_pickup_time-30 min, current_dropoff_time+30 min]; c) there is a reservation whose pickup time <= current_pickup_time – 30 min and droppoff_time >= current_dropoff_time + 30 min (i.e., spans the whole duration of current reservation).

4) the car assigned to the driver can hold that many passengers.

If an available driver is found, the system creates the reservation and prints out a reservation number. Otherwise, the system prints out a no car is available message.

4. A customer can cancel a reservation by providing username, password, and the reservation number.

5. Reporting and data analysis: Please implement the following two reporting procedures. You can print out the results.

- Find the k (k as input parameter) customers who have made the most reservations.

- Find the k pairs of zip codes (as pick up location and destination) with the highest number of reservations.

Habilidades: MySQL, Oracle, SQL

Veja mais: zip car, min range, car reservations, booking a car, car codes, sql data analysis, car booking, can cancel following, find car location, taxi mysql, mysql taxi, sql implement, implement booking system, car booking system, print driver create, trip system, system taxi, sql message system, taxi reservations system, online booking taxi system, reservations mysql, assign system, taxi codes system, reservation system payment, zip codes mysql

Acerca do Empregador:
( 1 comentário ) Bowie, United States

ID do Projeto: #6831597

Concedido a:


Propunerea nu a fost încă furnizată

$155 USD em 1 dia
(9 Comentários)

15 freelancers are bidding on average $363 for this job


Hi, I have gone through your requirements, I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,PL/SQL,T-SQL,MySql,MSSQL Server,PostgreSQL,Oracle database, data Mais

$736 USD in 20 dias
(27 Comentários)

HI Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us Mais

$155 USD in 3 dias
(11 Comentários)

We have gone through your initial requirements. We have very good expertise in this field and confident to provide you best quality result with high satisfaction. Please take a look on our efforts: [url removed, login to view] Mais

$4123 USD in 35 dias
(6 Comentários)

Dear Client,i am Website designer & developer within 5 years i have read your all requirement and am very confident to fulfill your all requirement in timely manner along with quality work i will provide you fully func Mais

$473 USD in 12 dias
(3 Comentários)

Hello ! I have made a car booking system before for a client .. you can see my completed task.. i made the script using php, jquery ajax,,, so i have a perfect experience in programming skill i can easily co Mais

$40 USD in 5 dias
(6 Comentários)

I can deliver it to you within [url removed, login to view] discuss and start project.I have years of experience in development and database.

$55 USD em 1 dia
(0 Comentários)

I am a web apps developer with 2.5 years industrial experience with php5 oops structure.i have done same type of project i.e car rental management system.

$1666 USD in 30 dias
(0 Comentários)

[url removed, login to view] [url removed, login to view] [url removed, login to view] Hello sir we have fully read your description and understand [url removed, login to view] did similar job [url removed, login to view] will design and developed the website as you want.w Mais

$600 USD in 25 dias
(1 Comentário)

I have experience in PHP, Java, MySQL, Oracle and I have worked with many web projects. I think I can help you with this project.

$277 USD in 10 dias
(0 Comentários)

Dear Hiring Manager, I have 2 years experience on Software,Web and Database development. I have a E-Commerce web Software. I could make taxi booking system. Thank you for this wonderful opportunity. I have excelle Mais

$250 USD in 3 dias
(0 Comentários)

Hello, I just checked your details, I have more than 7+ years’ experience with Joomla, Drupal, MODx CMS and WordPress, Magento with 3 year & will sure 100% work done within a time. We are also work with Core PHP, Mais

$100 USD in 3 dias
(0 Comentários)

A proposal has not yet been provided

$277 USD in 30 dias
(0 Comentários)

hello employer, I have done this kind of projects before. Consider me and get it done perfectly as well as quickly too. Come for the discussion for more details. Thanks & Regards, Shiva.

$444 USD in 7 dias
(0 Comentários)

I have 5 years of industry into java/j2ee technologies with sql,mysql , I can develop this application with good quality code and performance and testing and ontime delivary with daily updates about the project

$111 USD in 3 dias
(0 Comentários)

plz come on chat now so we can discuss waiting... Dear Sir, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to Mais

$100 USD in 3 dias
(0 Comentários)

Hello, we have excellent team of programmers and designers to work on your project efficiently and complete job in time. We have read your deepest requirement at our best and will surely give better results. Please rep Mais

$166 USD in 3 dias
(0 Comentários)