Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions

Question

Knowledge of project management (PMI) teachings

Answered: 1 week ago

Question

What is the purpose of the Salary Structure Table?

Answered: 1 week ago

Question

What is the scope and use of a Job Family Table?

Answered: 1 week ago