@dpatil

create table Station(Station_ID int, Name varchar(15), City varchar(15), State varchar(15)); create table Ticket(Ticket_ID int, Class varchar(30), Price int, Booking_Date date, Booking_Clerk varchar(15), Passenger_ID int, Trip_ID int, Foreign Key(Passenger_ID) references Passenger(Passenger_ID), Foreign Key(Trip_ID) references Trip(Trip_ID)); create table Train(Train_ID int, Model varchar(15), Number_of_seats int, Maximum_Speed int, Number_of_coaches int, Manufacturing_date date, Driver_ID int,

create table Passenger(Passenger_ID int, First_name varchar(15), Last_name varchar(15)); create table Passenger_Contact(Passenger_ID int, Passenger_mail varchar(30), City varchar(15), State varchar(25), Foreign Key(Passenger_ID) references Passenger(Passenger_ID)); create table Passenger_Phone(Passenger_ID int, Phone_number int, Foreign Key(Passenger_ID) references Passenger(Passenger_ID)); create table Route(Source_ID int, Destination_ID varchar(15)); insert into Passenger values ("P0001", "Do

create table Employee(Employee_ID int, First_name varchar(15), Last_name varchar(15), Birthdate date, Salary int, Job_ID int, Station_ID int, Primary Key(Employee_ID), Foreign Key(Job_ID) references Job(Job_ID), Foreign Key(Station_ID) references Station(Station_ID)); create table Employee_Contact(Employee_ID int, Employee_mail varchar(30), City varchar(15), State varchar(25), Foreign Key(Employee_ID) references Employee(Employee_ID)); create table Employee_Phone(Employee_ID int, Phone_number i