Question: How can I code this using sql oracle, This System is for Uber company What type of data I use for the pick up location

How can I code this using sql oracle, This System is for Uber company What type of data I use for the pick up location and drop off as well as the distance will be the long between/ also the fare amount will depend on the distance
Will It be calculated column or should I enter predefined data the following are sample of what we have done in class
 How can I code this using sql oracle, This System is
for Uber company What type of data I use for the pick
up location and drop off as well as the distance will be

FK PASSENGER ID FK DRIVER ID RIDE PK RIDE ID RIDE DATIE PICKUP TIME PICKUP LOCATION DROPPOFF LOCATION CAR TYPE DISTANCE KM ESTIMATED TIME FARE AMOUNT RIDE STATUS PAYMENT PKI PAYMENT ID PAYMENT TIME PAYMENT DATE PAYMENT MATHOD PAYMENTAMOUNT FK PASSENGER ID FK DRIVER ID FK PAYMENT ID OH PROMOTION K RIDE ID PK PROMOTION ID PROMOTION CODE START DATE END DATE PAYPAL DISCOUNT PERCENT Cash DISCOUNT AMOUNT PROMOTION PRICE CC NUMBER EXPIRY DATE CARD NAME PAYPAL ACCOUNT INVOICE ID FK PAYMENT ID | | SECURTY CODE FK PASSENGER ID FK DRIVER ID RIDE PK RIDE ID RIDE DATIE PICKUP TIME PICKUP LOCATION DROPPOFF LOCATION CAR TYPE DISTANCE KM ESTIMATED TIME FARE AMOUNT RIDE STATUS PAYMENT PKI PAYMENT ID PAYMENT TIME PAYMENT DATE PAYMENT MATHOD PAYMENTAMOUNT FK PASSENGER ID FK DRIVER ID FK PAYMENT ID OH PROMOTION K RIDE ID PK PROMOTION ID PROMOTION CODE START DATE END DATE PAYPAL DISCOUNT PERCENT Cash DISCOUNT AMOUNT PROMOTION PRICE CC NUMBER EXPIRY DATE CARD NAME PAYPAL ACCOUNT INVOICE ID FK PAYMENT ID | | SECURTY CODE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!