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)