Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Populate the database (will be below) with data. Write the SQL insert script to enter at least 10 rows of data for each table. Be

Populate the database (will be below) with data. Write the SQL insert script to enter at least 10 rows of data for each table. Be sure the inserts go in the correct order. ( I need help with this problem, thank you so much!)

CREATE TABLE TRAIN ( TRAIN_NO INT(10) PRIMARY KEY, TRAIN_NAME VARCHAR(20), SOURCE_SID VARCHAR(20), DESTINATION_SID VARCHAR(20), TRAIN_TYPE VARCHAR(20) )

CREATE TABLE TRAIN_AC2 ( TRAIN_NO INT(20), FOREIGN KEY (TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), AC2_FARE INT(30), AC2_SEAT INT(30) )

CREATE TABLE TRAIN_AC1 ( TRAIN_NO INT (20), FOREIGN KEY(TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), AC1_FARE INT(30), AC1_SEAT INT(30) )

CREATE TABLE TRAIN_SL ( TRAIN_NO INT(20), FOREIGN KEY ( TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), SL_FARE INT(30), SL_SEAT INT(30))

CREATE TABLE STATION( STATION_ID INT(20) PRIMARY KEY, STATION_NAME VARCHAR(20))

CREATE TABLE STATION_ROUTE ( STATION_ID INT(20), FOREIGN KEY(STATION_ID) REFERENCES STATION(STATION_ID), TRAIN_NO INT(20), FOREIGN KEY ( TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), STOP_NO INT(20), FOREIGN KEY(STOP_NO) REFERENCES ROUTE(STOP_NO))

CREATE TABLE ROUTE ( TRAIN_NO INT(20), FOREIGN KEY ( TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), STOP_NO INT(20) PRIMARY KEY, ARRIVAL_TIME INT(20), DEPT_TIME INT(20), DESTINATION VARCHAR(20))

CREATE TABLE USER_REGISTRATION ( USER_ID INT(20) PRIMARY KEY, USER_NAME VARCHAR(20), USER_PASSWORD VARCHAR(20), USER_EMAIL VARCHAR(20), USER_ADDRESS INT(20), USER_PHONE INT(20))

CREATE TABLE PASSENGER ( TICKET_ID INT(20), PASSENGER_NAME VARCHAR(20), PASSENGER_AGE INT(20), PASSENGER_SEX VARCHAR(10), PASSENGER_SEATNO INT(30), TRAIN_NO INT(20), FOREIGN KEY(TRAIN_NO) REFERENCES TRAIN(TRAIN_NO))

CREATE TABLE TICKET_RESERVATION( USER_ID INT(20), FOREIGN KEY(USER_ID) REFERENCES user_registration(USER_ID), TICKET_ID INT(20), TRAIN_NO INT(20), FOREIGN KEY(TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), DATE_AVAIABLE VARCHAR(20), DATE_STATUS VARCHAR(20))

CREATE TABLE TRAINSL_STATUS ( TRAIN_NO INT(20), FOREIGN KEY (TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), DATE_AVAIABLE VARCHAR(20), SL_RESERVESEATS INT(30), SL_WAITINGSEATS INT(30), SL_AVAIABLESEATS INT(30))

CREATE TABLE AC1_STATUS ( TRAIN_NO INT(20), FOREIGN KEY (TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), DATE_AVAIABLE VARCHAR(20), AC1_RESERVESEATS INT(30), AC1_WAITINGSEATS INT(30), AC1_AVAIABLESEATS INT(30))

CREATE TABLE AC2_STATUS ( TRAIN_NO INT(20), FOREIGN KEY (TRAIN_NO) REFERENCES TRAIN(TRAIN_NO), DATE_AVAIABLE VARCHAR(20), AC2_RESERVESEATS INT(30), AC2_WAITINGSEATS INT(30), AC2_AVAIABLESEATS INT(30))

CREATE TABLE PASSENGER_STATUS ( TICKET_ID INT(20), SOURCE_ID VARCHAR(20), DESTINATION_ID VARCHAR(20), TICKET_CLASS VARCHAR(20), PASSENGER_TICKETSTATUS VARCHAR(20), TRAIN_ID INT(20))

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Databases With PostgreSQL From Novice To Professional

Authors: Richard Stones, Neil Matthew

2nd Edition

1590594789, 978-1590594780

More Books

Students also viewed these Databases questions

Question

4. Why is it that correlations do not imply causation?

Answered: 1 week ago