iEiNkLDJ

1CREATE DATABASE IF NOT EXISTS 0408982209_GAGN2HS05BU_Skilaverkefni_2;
2
3CREATE TABLE IF NOT EXISTS employee (
4	EMP_NUM INT NOT NULL AUTO_INCREMENT,
5    EMP_LNAME VARCHAR(30),
6    EMP_FNAME VARCHAR(30),
7    EMP_INITIAL VARCHAR(10),
8    EMP_HIREDATE DATE,
9    JOB_CODE INT NOT NULL, # foreign key
10    EMP_YEARS INT,
11    #FOREIGN KEY ()
12);
13
14CREATE TABLE IF NOT EXISTS job (
15	JOB_CODE INT NOT NULL AUTO_INCREMENT,
16    JOB_DESCRIPTION VARCHAR(50),
17    JOB_CHG_HOUR FLOAT,
18    JOB_LAST_UPDATE DATE
19);
20
21CREATE TABLE IF NOT EXISTS assignment (
22	ASSIGN_NUM INT NOT NULL AUTO_INCREMENT,
23    ASSIGN_DATE DATE,
24    PROJ_NUM INT NOT NULL, # foreign key
25    EMP_NUM INT NOT NULL, # foreign key
26    ASSIGN_JOB INT,
27    ASSIGN_CHG_HR FLOAT,
28    ASSIGN_HOURS FLOAT,
29    ASSIGN_CHARGE FLOAT
30);
31
32CREATE TABLE IF NOT EXISTS project (
33	PROJ_NUM INT NOT NULL AUTO_INCREMENT,
34    PROJ_NAME VARCHAR(50),
35    PROJ_VALUE FLOAT,
36    PROJ_BALANCE FLOAT,
37    EMP_NUM INT NOT NULL # foreign key
38);