Java backend part 21

 SQL script:

DROP DATABASE IF EXISTS FullStackDev;

CREATE DATABASE IF NOT EXISTS FullStackDev;

USE FullStackDev;

-- Create table Employee --

CREATE TABLE `Employee` (

id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,

    `name` VARCHAR(50) NOT NULL

);

-- Create table RegularEmployee --

CREATE TABLE `RegularEmployee` (

id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,

    `name` VARCHAR(50) NOT NULL,

salary INT NOT NULL,

    bonus INT NOT NULL,

    FOREIGN KEY (id) REFERENCES `Employee`(id)

);

-- Create table ContractEmployee --

CREATE TABLE `ContractEmployee` (

id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,

    `name` VARCHAR(50) NOT NULL,

    pay_per_hour INT NOT NULL,

    contract_duration VARCHAR(50) NOT NULL,

    FOREIGN KEY (id) REFERENCES `Employee`(id)

);

INSERT INTO `Employee` (`name`)

VALUE ('name1'),

  ('name2'),

      ('name3');

      

INSERT INTO `RegularEmployee` (`name`, salary, bonus)

VALUE ('name1', 2000, 100),

  ('name2', 2000, 200);

      

INSERT INTO `ContractEmployee` (`name`, pay_per_hour, contract_duration)

VALUE ('name3', 10, '3 years');