1-2-1 Relationship

CREATE TABLE Passports (
PassportID INT NOT NULL ,
PassportNumber VARCHAR(MAX) NOT NULL
)

CREATE TABLE Persons (
PersonID INT NOT NULL IDENTITY,
FirstName VARCHAR(MAX) NOT NULL,
Salary DECIMAL,
PassportID INT NOT NULL UNIQUE
)

ALTER TABLE Persons
ADD CONSTRAINT Ps_Person_Pk PRIMARY KEY (PersonId)

ALTER TABLE Passports
ADD CONSTRAINT Pk_Passport_ID PRIMARY KEY (PassportID)

ALTER TABLE Persons
ADD CONSTRAINT Ps_Person_ID FOREIGN KEY (PassportID)
REFERENCES Passports (PassportID)

INSERT INTO Passports
VALUES (101,'N34FG21B'),(102,'K65LO4R7'),(103,'ZE657QP2')

INSERT INTO Persons
VALUES ('Roberto',43300.00,101),('Tom',56100.00,102),('Yana',60200.00,103)