MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `Employee` (
  `SSN` int,
  `address` varchar(50),
  `salary` varchar(50),
  `sex` varchar(50),
  `birthDate` varchar(50),
  `dependantId` int,
  `supervisorId` int,
  PRIMARY KEY (`SSN`),
  FOREIGN KEY (`dependantId`) REFERENCES `Employee`(`SSN`),
  FOREIGN KEY (`supervisorId`) REFERENCES `Employee`(`SSN`)
);
INSERT INTO Employee VALUES (1,'adreess1','10', 'male', '2000-01-01',NULL,NULL)
INSERT INTO Employee VALUES (2,'adreess1','10', 'male', '2000-01-01',NULL,1)
INSERT INTO Employee VALUES (3,'adreess1','10', 'male', '2000-01-01',2,1)
SELECT * FROM Employee


SSN
address
salary
sex
birthDate
dependantId
supervisorId


1
adreess1
10
male
2000-01-01
null
null

2
adreess1
10
male
2000-01-01
null
1

3
adreess1
10
male
2000-01-01
2
1

SSN	address	salary	sex	birthDate	dependantId	supervisorId
1	adreess1	10	male	2000-01-01	null	null
2	adreess1	10	male	2000-01-01	null	1
3	adreess1	10	male	2000-01-01	2	1