MIS582 Database Concepts - 10723
Final Course Project
Module 8
Student Name
Date
Professor: Dr Nana Liu
, 1. ERD diagram
2. b. Create Tables (Employee, EmpSkill, Skill, Region, and Customer) and Insert Data
CREATE TABLE REGION (
RegionID VARCHAR(4) NOT NULL PRIMARY KEY,
RegionName VARCHAR(20) NOT NULL);
CREATE TABLE EMPLOYEE (
EmpID VARCHAR(4) NOT NULL PRIMARY KEY,
EmpLastName VARCHAR(255) NOT NULL,
EmpFirstName VARCHAR(255) NOT NULL,
EmpInitial CHAR,
EmpHireDate DATE NOT NULL,
RegionID VARCHAR(4) NOT NULL,
FOREIGN KEY(RegionID) REFERENCES REGION(RegionID));
CREATE TABLE SKILL (
SkillID VARCHAR(4) NOT NULL PRIMARY KEY,
Final Course Project
Module 8
Student Name
Date
Professor: Dr Nana Liu
, 1. ERD diagram
2. b. Create Tables (Employee, EmpSkill, Skill, Region, and Customer) and Insert Data
CREATE TABLE REGION (
RegionID VARCHAR(4) NOT NULL PRIMARY KEY,
RegionName VARCHAR(20) NOT NULL);
CREATE TABLE EMPLOYEE (
EmpID VARCHAR(4) NOT NULL PRIMARY KEY,
EmpLastName VARCHAR(255) NOT NULL,
EmpFirstName VARCHAR(255) NOT NULL,
EmpInitial CHAR,
EmpHireDate DATE NOT NULL,
RegionID VARCHAR(4) NOT NULL,
FOREIGN KEY(RegionID) REFERENCES REGION(RegionID));
CREATE TABLE SKILL (
SkillID VARCHAR(4) NOT NULL PRIMARY KEY,
