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
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
Get step-by-step solutions from verified subject matter experts
