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 Write a query to delete payment details from payments table where discount coupon 'D1' was applied.Hint: Data is case sensitiveBUSESBUS NOnumber(11)BUS_NAME varchar2(20) tvarchar2(20) tTOTAL_SEATS number(11) #AVAIL_SEATS number(11) #SCHEDULEvarchar2(3)date dvarchar2(20) tDESTINATION varchar2(20) tSCHEDULE_IDTRAVEL_DATETYPESOURCEO BUS_NODURATIONnumber(11) U NOnumber(11) #PAYMENTSDISCOUNTSP PAYMENT_ID varchar2(3) tDISCOUNT_IDDISCOUNT_AMOUNT number(11) #TICKET IDvarchar2(3)BD IDO O TICKET_IDFOO BD_IDO DISCOUNT_ID varchar2(3)varchar2(3)number(11) DISCOUNT_IDTICKETSTICKET IDvarchar2(3) HEDULE IDp onumber(11) #USER IDnumber(11) Onumber(11) #SCHEDULE ID varchar2(3)FAREPUSER_IDUSERSNO SEATSPUSER_ID number(11)varchar2(20) tADDRESS varchar2(100) tnumber(11) #EMAILID varchar2(30) t2 primary key - not nullNAMEO foreign keyPHNO# data type - numberd data type - dateCANCELLATIONt data type - varchar2CANCELLATION_ID varchar2(3) tO TICKET IDO BD_IDTICKET IDBOOKINGDETAILSvarchar2(3)number(11) D_IDP BD_ID number(11)ACC_NO number(11) #NAME varchar2(10) tOUSER_ID number(11)USER ID

According to the Question below the Solution

Answered: SCHEDULE ID Write a query to delete…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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