Bill was a rancher and owned 500 sheep. Vandals cut a hole in the fence that kept Bill’s sheep in his pasture and 200 sheep escaped from the hole. The….
Tracking Trips for the SchUber Taxi Service A new Philadephia startup called SchUber
Tracking Trips for the SchUber Taxi Service A new Philadephia startup called SchUber is a matching service between freelance taxi drivers and passengers. The database to support the service tracks trips, customer accounts, and includes a rating system where drivers and passengers can rate each other. The basic transaction for SchUber is the trip. A trip is described by the date and time the trip occurs and the fare. A trip involves one driver and at least one passenger. A driver has a first name, a last name, a social security number, and an email address. A passenger has a first name, last name, and an email address. A trip is also associated with at least two addresses. An address is also described by the street address, city, state, and zip code. Each address must be designated as either an origin or destination address for the trip. Each address also has an attribute which designates the address as a home address for a passenger – this is useful for billing and for making a request for a home pick-up. However, a passenger can only have one address (their home address) associated with their account. A passenger pays for the trip using any one of the payment methods linked to their account. Valid payment method types are PayPal, Credit Card, or Google Wallet. Credit cards also have an expiration date, but this information is not needed for PayPal or Google Wallet. Passengers cannot share a payment method, but if there are multiple passengers on a trip they can each pay their share, and each of their payments can be a different amount (which should be recorded in the database) to the fare. The rating system is one of the key features of SchUber. Both drivers and passengers can have ratings, although they may not have any ratings, especially if they just started with the service. When a driver or a passenger submits the rating, they give a star rating (1 to 5), brief comments, and the type of review (i.e., for driver or for passenger). SchUber users can look up ratings by driver, passenger, or by trip (a trip could have more than two ratings if there were multiple passengers on the trip).