By: Zachary Pappas, Jonathon Ydrogo, Janet Huong, Ting Yan, and Andrew Dixon
1
Summary★Founded 2009 in San Francisco, California★Application connecting drivers with people who need a ride★Allows customers to arrange and schedule transportation and/or
logistics services with third party providers★Provides business travel for employees★UberRUSH delivers for Shopify, Clover, Delivery.com,
1800Flowers, etc.★UberEATS gets you the food you want from the restaurants you
love. Open the app, find what you're craving, and it is delivered to you. 2
Business Rules1. Drivers must be over 18 years old2. Drivers must have a driver’s license3. Customers must have a credit card4. Drivers’ vehicle must be insured5. Drivers must have at least one vehicle; one vehicle can only belong
to many drivers6. Vehicle cannot be older than 10 calendar years7. One paying customer per ride request8. Customers’ geographic information and destination location will be
collected upon ride request3
Business Rules1. Active drivers’ geographic information will always be displayed to
customers2. Customers’ geographic information will be sent to driver after ride
request is accepted by driver3. After ride is complete, information about the ride will be stored (ex.
customer ratings, driver ratings, price, distance, duration)4. Each ride will be identified by an identification number5. Each person will be identified by an identification number6. Each vehicle will be identified by its VIN7. Drivers can have one or many ride requests8. Ride requests can only have one driver9. Customer and driver reviews are optional
4
ER Model
5
EER Model
6
7
Logical DesignPerson (Person_ID, First_Name, Last_Name, User_Name, DOB, Phone_Number, Email, Person_Type (C,D))
Customer (Person_ID, Credit_Card_Number)
Driver (Person_ID, Drivers_License_Number)
DriversVehicles(Person_ID, VIN)
Vehicle (VIN, Person_ID, Make, Model, Year, License_Plate, Insurance_Number)
Ride (Order_ID, Driver_ID, Customer_ID, VIN, Duration, Distance, Price, Customer_Location, Destination_Location, Customer_Review, Driver_Review)
Data Integrity
8
Query #1Determine which rides were longer than 10 miles:
select order_IDfrom ridewhere distance > '10.0';
9
Query #2Determine which vehicles are greater than 2010:
select modelfrom vehiclewhere year>'2010';
10
Query #3Show which drivers were associated with customer ID 77182804:
select customer_ID, driver_IDfrom ridewhere customer_ID='77182804';
11
Query #4Determine the first name, last name, and DOB of all persons born before July 16, 1991:
Select firstname, lastname, DOBfrom personwhere DOB<'16-jul-91';
12
Query #5Shows the current age of the individual
select firstname, lastname, DOB, round((sysdate-DOB)/'365') agefrom person;
13
ConclusionThe database provides storage for company information including:
● Person Information● Customer Information● Driver Information● Vehicle Information● Ride Information
The data collected can be used to analyze and monitor company progression.The data can also help to determine the need for additional vendors in different locations. 14
Top Related