Foreign key multiple columns

CREATE TABLE Employee(
    EmployeeID int NOT NULL PRIMARY KEY,
    LastName varchar(50) NOT NULL,
    FirstName varchar(20) NOT NULL,
    Age int,
    DeptNo int,
    PRIMARY KEY (EmployeeID),
    CONSTRAINT FK_PersonOrder FOREIGN KEY (DeptNo)
    REFERENCES Department(DeptNo)
);

Source: computerscienceai.com

Similar codes

-1 vote143 views1 answer
Brisanje dupliranih konatakata
SQL
1 vote94 views1 answer
Mysql select another database
SQL
0 vote107 views1 answer
Basic structure of sql expression having clause
SQL
3 votes105 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote127 views1 answer
Reindexing all tables sql server
SQL
-1 vote106 views1 answer
Mysql order by on condition
SQL
1 vote98 views1 answer
Set mysql mode global query
SQL
0 vote113 views1 answer
How to query all tables mysql at the same time
SQL
1 vote107 views2 answers
Populate sql table with random data
SQL
1 vote106 views1 answer
Sql server cast date dd/mm/yyyy
SQL