Refer the below schema and create the SCHEDULE. Column Datatype Size Constraint Constraint name Reference table Name Column name Schedule_id Travel_date Primary key PK SCHEDULE Varchar2 3 Date Source...

SQL

Extracted text: Refer the below schema and create the SCHEDULE. Column Datatype Size Constraint Constraint name Reference table Name Column name Schedule_id Travel_date Primary key PK SCHEDULE Varchar2 3 Date Source Varchar2 20 Destination Bus_no Duration Varchar2 Number Number 20 11 Foreign key FK SCHEDULE_BUSES Buses - bus_no 11 (Hint: Assume that the parent table 'BUSES' has been already created) BUSES number(11) BUS_NAME varchar2(20) varchar2(20)t TOTAL_SEATS number(11) AVAIL SEATS number(11) BUS NO SCHEDULE varchar2(3) SCHEDULE ID TRAVEL DATE TYPE date d varchar2(20)t SOURCE DESTINATION varchar2(20) BUS NO O BUS_NO number(11) DURATION number(11) PAYMENTS DISCOUNTS varchar2(3) PAYMENT ID Vvarchar2(3) TICKET ID O BD_ID O DISCOUNT_ID varchar2(3) DISCOUNT_ID DISCOUNT_AMOUINT number(11) # TICKET ID varchar2(3) number(11) TICKETS DISCOUNT ID varchar2(3) SCHEDULE_ID varchar2(3) number(11) a number(11) number(11) a TICKET ID CHEDULE ID FARE USER ID pUSER_ID USERS NO SEATS USER_ID number(11) primary key - not null NAME varchar2(20)t e foreign key # data type - number ADDRESS varchar2(100) t PHNO number(11)a EMAILID varchar2(30) t d data type - date CANCELLATION It| data type - varchar2 CANCELLATION_ID varchar2(3) t P TICKET ID O BD ID TICKET ID BOOKINGDETAILS varchar2(3) number(11) BD ID BD_ID number(11) ACC_NO number(11) * NAME varchar2(10) t PUSER ID number(11) USER_ID