MIS 582 Week 8 Final Course Project
Document Preview
Unlock the full 10 document instantly.
Document Overview
MIS582 Database Concepts Final Course Project Module 8 Professor: Dr Nana Liu ERD diagram 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, SkillDe
Full content available after purchase or with an active subscription.
Related Products
Related Products
MIS 582 Week 4 Project; Database Relationships and ERD Creation
MIS 582 Week 3 Project Deliverable; SQL Queries and Screenshots
MIS 582 Week 6 Project Deliverable; SQL Queries
MIS 582 Week 5 Project Deliverable; SQL Table Structure & Queries.
Academic Use Notice: This resource is provided strictly as study support material to help students review concepts, understand topic structure, and prepare their own original academic work responsibly. It is not intended to be submitted directly as a student's own work.