References Key in SQL

Question

hi

please help me

use hospital_database
go
CREATE TABLE Department (
DepartmentID int NOT NULL,
Name varchar(30),
EmployeeID int ,
Primary Key (DepartmentID),
FOREIGN KEY (EmployeeID) REFERENCES Physician(EmployeeID)
);

this is my table Structure

my question is How will you cross check this

i need insert a data right?

try to enter the employeeid which is not phyisician table

i dont know please send me a query

and iam also give physician table structure:

EmployeeID int not null, it should be primary key

Name varchar(30),

Position varchar(200),

SSN Numeric(9,0)