I'm new to SQL and trying to make it so that there are two primary keys and one foreign key that references other tables primary key.

I've tried adding the attribute that is a primary key that is missing the table that needs referencing and then making that a foreign key but still getting the message that "number of referencing columns must match references columns".

if there is a solution to what I'm trying to achieve it would be much appreciated.

```sql
CREATE TABLE Next_of_Kin
 (
   Employee_No       VARCHAR2(8)  NOT NULL,
   kin_Number        VARCHAR2(8)  NOT NULL,
   Name              VARCHAR2(40) NOT NULL,
   relationship      VARCHAR2(40) NOT NULL,
   contact_number    VARCHAR2(11) NOT NULL,
   PRIMARY KEY (Employee_No, Kin_Number),
   FOREIGN KEY (Employee_No, Kin_Number) REFERENCES Employee(Employee_No) 
 );

CREATE TABLE Employee 
( 
  Employee_No   VARCHAR2(8)  NOT NULL, 
  family_Name   VARCHAR2(40) NOT NULL, 
  given_Name    VARCHAR2(40) NOT NULL, 
  address       VARCHAR2(80) NOT NULL, 
  date_of_Birth DATE         NOT NULL, 
  date_Hired    DATE         NOT NULL, 
  supervisor    VARCHAR2(40) NULL, 
  PRIMARY KEY (Employee_No, Supervisor), 
  FOREIGN KEY (Employee_No,Supervisor) 
  REFERENCES Employee(Employee_No, Supervisor) 
);

```