__________Tables__________

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

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

CREATE TABLE Pay_Grade
(
  grade_id INT NOT NULL AUTO_INCREMENT,
  grade_name VARCHAR(50) NOT NULL,
  grade_basic DECIMAL(15,2) NOT NULL,
  grade_da DECIMAL(15,2) NOT NULL,
  grade_ta DECIMAL(15,2) NOT NULL,
  grade_bonus DECIMAL(15,2) NOT NULL,
  grade_pf DECIMAL(15,2) NOT NULL,
  Dept_id INT NOT NULL,
  PRIMARY KEY (grade_id),
  FOREIGN KEY (Dept_id) REFERENCES Department(Dept_id)
);

CREATE TABLE Payroll
(
  transaction_id INT NOT NULL AUTO_INCREMENT,
  emp_net_sal DECIMAL(15,2) NOT NULL,
  reinbursment_dat date NOT NULL,
  emp_gross DECIMAL(15,2) NOT NULL,
  emp_sal_month DECIMAL(15,2) NOT NULL,
  emp_sal_year DECIMAL(15,2) NOT NULL,
  emp_id INT NOT NULL,
  grade_id INT NOT NULL,
  PRIMARY KEY (transaction_id),
  FOREIGN KEY (grade_id) REFERENCES Pay_Grade(grade_id),
  FOREIGN KEY (emp_id) REFERENCES Employee(emp_id)
);

CREATE TABLE Employee
(
  emp_id INT NOT NULL AUTO_INCREMENT,
  emp_name VARCHAR(50) NOT NULL,
  emp_contact_no VARCHAR(50) NOT NULL,
  emp_DOB date NOT NULL,
  emp_state VARCHAR(50) NOT NULL,
  emp_city VARCHAR(50) NOT NULL,
  emp_DOJ date NOT NULL,
  Dept_id INT NOT NULL,
  PRIMARY KEY (emp_id),
  FOREIGN KEY (Dept_id) REFERENCES Department(Dept_id)
);