Please help me to determine the business rules from these tables and the relatio
ID: 3668578 • Letter: P
Question
Please help me to determine the business rules from these tables and the relationships each has.
Thank you.
Entities and Attributes
TRAIN (Entity)
TRAIN_SCHEDULE (Entity)
TRAIN_SEATS (Entity)
TRAIN_ID(FK)
TRAIN_ID (FK)
SEAT_ID
TRAIN NAME(PK)
STATION_ID {station, reservation}
SEAT_NUMBER (PK)
ARRIVAL_TIME
TRAIN_ID (FK)
DEPARTURE_TIME (PK)
STATION (Entity)
PASSENGER (Entity)
RESERVATION (Entity)
STATION_ID (FK)
PASSENGER_ID (FK)
RESERVATION_ID
STATION_NAME (PK)
PASSENGER_FIRSTNAME
PASSENGER_ID (FK)
STATION_LOCATION
PASSENGER_LASTNAME (PK)
DATE_OF_TRAVEL (PK)
ADDRESS
STATION_ID
PHONE_NUMBER
SEAT_RESERVATION (Entity)
SEAT_ID
RESERVATION_ID
I also can't figure out which should be the Primary Key (PK) and the Foreign Key (FK) in the SEAT-RESERVATION entity table.
Thank you
TRAIN (Entity)
TRAIN_SCHEDULE (Entity)
TRAIN_SEATS (Entity)
TRAIN_ID(FK)
TRAIN_ID (FK)
SEAT_ID
TRAIN NAME(PK)
STATION_ID {station, reservation}
SEAT_NUMBER (PK)
ARRIVAL_TIME
TRAIN_ID (FK)
DEPARTURE_TIME (PK)
Explanation / Answer
TRAIN (Entity)
TRAIN_ID (PK)
TRAIN NAME(PK)
TRAIN_SCHEDULE (Entity)
TRAIN_ID(FK)
STATION_ID (FK){station, reservation}
ARRIVAL_TIME
DEPARTURE_TIME
TRAIN_SEATS (Entity)
COACH_ID (PK)
SEAT_NUMBER (PK)
TRAIN_ID (FK)
STATION (Entity)
STATION_ID (PK)
STATION_NAME (PK)
STATION_LOCATION
RESERVATION (Entity)
RESERVATION_ID(PK)
SOURCE_STATION_ID
DESTINATION_STATION_ID
PASSENGER_RESERVATION_INFO (Entity)
RESERVATION_ID(FK)
PASSENGER_FIRSTNAME
PASSENGER_LASTNAME
DATE_OF_TRAVEL
ADDRESS
PHONE_NUMBER
SEAT_RESERVATION (Entity)
SEAT_ID (FK)
RESERVATION_ID(FK)