SCHEDULE ID Write a query to delete payment details from payments table where discount coupon 'D1' was applied. Hint: Data is case sensitive BUSES number(11) BUS_NAME varchar2
SCHEDULE ID Write a query to delete payment details from payments table where discount coupon 'D1' was applied. Hint: Data is case sensitive BUSES number(11) BUS_NAME varchar2(20) t varchar2(20) t TOTAL SEATS number(11) # AVAIL SEATS number(11) # BUS_NO SCHEDULE SCHEDULE_ID varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t number(11) O number(11) # TYPE TRAVEL DATE SOURCE BUS NO O BUS_NO DURATION PAYMENTS DISCOUNTS PAYMENT_ID varchar2(3) t varchar2(3) number(11) O DISCOUNT_ID varchar2(3) TICKET ID BD I0O O TICKET_ID O P BD_ID PDISCOUNT_ID DISCOUNT_AMOUNT number(11) # varchar2(3)/ TICKETS DISCOUNT_ID TICKET ID O SCHEDULE_ID number(11) # USER_ID number(11) O FARE O USER ID NO SEATS USERS number(11) # PUSER_ID number(11) varchar2(20) t ADDRESS varchar2(100) t number(11) # EMAILID varchar2(30) t P primary key - not null NAME o foreign key PHNO # data type - number d data type - date CANCELLATION t| data type - varchar2 CANCELLATION_ID varchar2(3) t Fo O TICKET_ID O BD ID TICKET ID BOOKINGDETAILS PBD ID number(11) ACC_NO number(11) # NAME varchar2(10) t pUSER_ID number(11) USER_ID
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
