What are the primary keys and foreign keys in these tables in SQL? Also, what is

Question

What are the primary keys and foreign keys in these tables in SQL?

Also, what is the code I used to designate these keys as such?

Thank you

TRAIN (table) TRAIN_ID TRAIN_NAME TRAIN_SCHEDULE (table) TRAIN_ID STATION_ID ARRIVAL_TIME DEPARTURE_TIME TRAIN_SEATS (table) SEAT_ID SEAT_NUMBER TRAIN_ID STATION (table) STATION_ID STATION_NAME STATION_LOCATION PASSENGER (table) PASSENGER_ID PASSENGER_FIRSTNAME PASSENGER_LASTNAME ADDRESS PHONE_NUMBER RESERVATION (table) RESERVATION_ID PASSENGER_ID DATE_OF_TRAVEL STATION_ID SEAT_RESERVATION (table) SEAT_ID RESERVATION_ID

Explanation / Answer

TRAIN (table)

TRAIN_ID

Primary Key

TRAIN_NAME

TRAIN_SCHEDULE (table)

TRAIN_ID

Foreign Key

STATION_ID

ARRIVAL_TIME

DEPARTURE_TIME

TRAIN_SEATS (table)

SEAT_ID

Primary Key

SEAT_NUMBER

TRAIN_ID

Foreign Key

STATION (table)

STATION_ID

Primary Key

STATION_NAME

STATION_LOCATION

PASSENGER (table)

PASSENGER_ID

Primary Key

PASSENGER_FIRSTNAME

PASSENGER_LASTNAME

ADDRESS

PHONE_NUMBER

RESERVATION (table)

RESERVATION_ID

Primary Key

PASSENGER_ID

Foreign Key

DATE_OF_TRAVEL

STATION_ID

Foreign Key

SEAT_RESERVATION (table)

SEAT_ID

Foreign Key

RESERVATION_ID

Foreign Key

Create table TRAIN
(
train_id int NOT NULL, train_name varchar(30), PRIMARY KEY(train_id)
)

TRAIN (table)

TRAIN_ID

Primary Key

TRAIN_NAME

TRAIN_SCHEDULE (table)

TRAIN_ID

Foreign Key

STATION_ID

ARRIVAL_TIME

DEPARTURE_TIME

TRAIN_SEATS (table)

SEAT_ID

Primary Key

SEAT_NUMBER

TRAIN_ID

Foreign Key

STATION (table)

STATION_ID

Primary Key

STATION_NAME

STATION_LOCATION

PASSENGER (table)

PASSENGER_ID

Primary Key

PASSENGER_FIRSTNAME

PASSENGER_LASTNAME

ADDRESS

PHONE_NUMBER

RESERVATION (table)

RESERVATION_ID

Primary Key

PASSENGER_ID

Foreign Key

DATE_OF_TRAVEL

STATION_ID

Foreign Key

SEAT_RESERVATION (table)

SEAT_ID

Foreign Key

RESERVATION_ID

Foreign Key

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.