How to use a primary key as FK in another table for 2 columns with different name for each column? : when I was trying to insert values to table Emps. I was required to insert 3. One For City_Id,departure_City_Id, and arrival_City_Id. I just want to insert to departure_City_Id, and arrival_City_Id. Please not: Values must be related to the PK in City table. Thanks in advance .


CREATE TABLE City (
City_Id char(3),
state varchar(30),
Primary key (City_Id)
);


create table Emps (

Emp_number varchar(30) primary key,

City_Id char(3),--Foreign Key

departure_City_Id char(3),
arrival_City_Id char(3),

 FOREIGN KEY (City_Id)
    REFERENCES City(City_Id),

 FOREIGN KEY (City_Id)
    REFERENCES City(City_Id)
);

