Refer the below schema and create the SCHEDULE. Column Datatype Size Constraint Constraint name Reference table - Column name Name Schedule_id Travel_date Source Destination Varchar2 3 Primary key PK_SCHEDULE Date Varchar2 Varchar2 Number Number 20 20 Bus_no Foreign key FK SCHEDULE BUSES Buses - bus_no 11 Duration 11 (Hint: Assume that the parent table 'BUSES' has been already created) BUSES number(11) BUS NO BUS NAME varchar2(20) t TYPE SCHEDULE SCHEDULE_ID varchar2(3)/ date d varchar2(20)t varchar2(20) number(11) number(11) # varchar2(20) t TRAVEL DATE SOURCE TOTAL_SEATS number(11) # AVAIL SEATS number(11) DESTINATION BUS NO O BUS NO DURATION

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...
icon
Related questions
Question
100%

database 

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
Transcribed Image 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
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY