CREATE TABLE Company
(
  company_id INT NOT NULL,
  company_name INT NOT NULL,
  company_address INT NOT NULL,
  contact_no INT NOT NULL,
  PRIMARY KEY (company_id)
);

CREATE TABLE Department
(
  Dept_id INT NOT NULL,
  Dept_name INT NOT NULL,
  company_id INT NOT NULL,
  PRIMARY KEY (Dept_id),
  FOREIGN KEY (company_id) REFERENCES Company(company_id)
);

CREATE TABLE Payroll
(
  emp_net_sal INT NOT NULL,
  transaction_id INT NOT NULL,
  reinbursment_dat INT NOT NULL,
  emp_gross INT NOT NULL,
  emp_sal_month INT NOT NULL,
  emp_id INT NOT NULL,
  emp_sal_year INT NOT NULL,
  PRIMARY KEY (transaction_id)
);

CREATE TABLE Employee
(
  emp_id INT NOT NULL,
  emp_name INT NOT NULL,
  emp_contact_no INT NOT NULL,
  emp_DOB INT NOT NULL,
  emp_state INT NOT NULL,
  emp_city INT NOT NULL,
  emp_DOJ INT NOT NULL,
  Dept_id INT NOT NULL,
  transaction_id INT NOT NULL,
  PRIMARY KEY (emp_id),
  FOREIGN KEY (Dept_id) REFERENCES Department(Dept_id),
  FOREIGN KEY (transaction_id) REFERENCES Payroll(transaction_id)
);

CREATE TABLE Pay_Grade
(
  grade_id INT NOT NULL,
  grade_basic INT NOT NULL,
  grade_da INT NOT NULL,
  grade_ta INT NOT NULL,
  grade_bonus INT NOT NULL,
  grade_pf INT NOT NULL,
  grade_name INT NOT NULL,
  transaction_id INT NOT NULL,
  Dept_id INT NOT NULL,
  PRIMARY KEY (grade_id),
  FOREIGN KEY (transaction_id) REFERENCES Payroll(transaction_id),
  FOREIGN KEY (Dept_id) REFERENCES Department(Dept_id)
);