9HBZJuGH

1CREATE DATABASE IF NOT EXISTS empdb;
2USE empdb;
3-- create tables
4CREATE TABLE merits (
5performance INT(11) NOT NULL,
6percentage FLOAT NOT NULL,
7PRIMARY KEY (performance)
8);
9CREATE TABLE employees (
10emp_id INT(11) NOT NULL AUTO_INCREMENT,
11emp_name VARCHAR(255) NOT NULL,
12performance INT(11) DEFAULT NULL,
13salary FLOAT DEFAULT NULL,
14PRIMARY KEY (emp_id),
15CONSTRAINT fk_performance FOREIGN KEY (performance)
16REFERENCES merits (performance)
17);
18-- insert data for merits table
19INSERT INTO merits(performance,percentage)
20VALUES(1,0),
21(2,0.01),
22(3,0.03),
23(4,0.05),
24(5,0.08);
25-- insert data for employees table
26INSERT INTO employees(emp_name,performance,salary)
27VALUES('Mary Doe', 1, 50000),
28('Cindy Smith', 3, 65000),
29('Sue Greenspan', 4, 75000),
30('Grace Dell', 5, 125000),
31('Nancy Johnson', 3, 85000),
32('John Doe', 2, 45000),
33('Lily Bush', 3, 55000);