CREATE TABLE employee_01 ( employee_email VARCHAR2(50) NOT NULL, employee_name VARCHAR2(100) NOT NULL, supervisor VARCHAR2(100) NULL );

CREATE TABLE job_01 ( job_desc VARCHAR2(100) NOT NULL, job_customer VARCHAR2(100), job_date DATE NOT NULL, job_status VARCHAR2(12) NOT NULL, job_status_change_date DATE NOT NULL );

CREATE TABLE tool_01 ( tool_no NUMBER(8) NOT NULL, tool_desc VARCHAR2(100) NOT NULL, tool_id_from_mfg VARCHAR2(50) NOT NULL, tool_mfg VARCHAR2(50) NOT NULL );

CREATE TABLE loan_01 ( tool_no NUMBER(8) NOT NULL, tool_desc VARCHAR2(100) NOT NULL, employee_email VARCHAR2(50) NOT NULL, job_desc VARCHAR2(100), tool_out_date DATE NOT NULL, due_date DATE, loan_active VARCHAR2(8) NOT NULL, loan_status_change_date DATE NOT NULL );

CREATE TABLE reserve_01( employee_email VARCHAR2(50) NOT NULL, tool_desc VARCHAR2(100) NOT NULL, job_desc VARCHAR2(100), reserve_active VARCHAR2(8) NOT NULL, reserve_status_change_date DATE NOT NULL );

CREATE TABLE hold_01( tool_no NUMBER(8) NOT NULL, tool_desc VARCHAR2(100) NOT NULL, employee_email VARCHAR2(50) NOT NULL, job_desc VARCHAR2(100), hold_date DATE NOT NULL, expire_date DATE, hold_active VARCHAR2(8) NOT NULL, hold_status_change_date DATE NOT NULL );

I am having a hard time normalizing these tables. I need explanation of how i can convert these into first , second and finally third normal form. I am having a hard time finding the primary key. I know for some we might have to create surrogate key as they done have unique keys.