MIS 582 Week 8 Final Course Project
Document Preview
Unlock Full 10 Page 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, SkillDescription VARCHAR(255) NOT NULL, SkillRate NUMERIC(4,2) NOT NULL); CREATE TABLE EMPSKILL ( EmpID VARCHAR(4) NOT NULL, SkillID VARCHAR(4) NOT NULL, FOREIGN KEY(EmpID) REFERENCES EMPLOYEE(EmpID), FOREIGN KEY(SkillID) REFERENCES SKILL(SkillID)); CREATE TABLE CUSTOMER ( CusID VARCHAR(4) NOT NULL PRIMARY KEY, CusName VARCHAR(255) NOT NULL, CusPhone VARCHAR(12), RegionID VARCHAR(4) NOT NULL, FOREIGN KEY(RegionID) REFERENCES REGION(RegionID)); INSERT INTO REGION (RegionID, RegionName) VALUES ('1001', 'Northwest'), ('1002', 'Southwest'), ('1006', 'Midwest North'), ('1007', 'Midwest South'), ('1003', 'Northeast'), ('1004', 'Southeast'), ('1005', 'Central'); INSERT INTO CUSTOMER (CusID, CusName, CusPhone, RegionID) VALUES (1, 'Bellsouth', '222-333-4571', '1003'), (2, 'Comcast', '253-444-5555', '1003'), (3, 'Enron', '367-555-6666', '1005'), (4, 'Exxon', '444-777-7777', '1004'), (5, 'See Rocks', NULL, '1001'), (6, 'AT&T', NULL, '1006'); INSERT INTO EMPLOYEE (EmpID, EmpLastName, EmpFirstName, EmpInitial, EmpHireDate, RegionID) VALUES ('E1', 'Schrimsher', 'Christopher', NULL, '2018-11-06', '1003'), ('E2', 'Khan', 'Salman', NULL, '2017-09-23', '1001'), ('E3', 'Roshan', 'Hritik', NULL, '2016-12-06', '1002'), ('E4', 'Pandey', 'Poonam', NULL, '2015-09-06', '1005'), ('E5', 'Rathi', 'Rahul', NULL, '2014-08-19', '1004'), ('E6', 'Rathi', 'Renu', NULL, '2020-12-20', '1007'), ('E7', 'Chandak', 'Lalit', NULL, '2009-05-06', '1006'), ('E8', 'Agarawal', 'Gaurav', NULL, '2008-11-01', '1001'), ('E9', 'Gandhi', 'Dhiraj', NULL, '2004-06-04', '1002'), ('E10', 'Sharma', 'Pratiksha', NULL, '2000-08-06', '1003'), ('E11', 'Dixit', 'Madhuri', NULL, '2002-11-07', '1004'), ('E12', 'Gehlot', 'Nidhi', NULL, '2007-10-08', '1005'), ('E13', 'Smith', 'Rebecca', NULL, '2010-11-09', '1006'), ('E14', 'Gomez', 'Pascal', NULL, '2011-08-12', '1007'), ('E15', 'Mims', 'Linda', NULL, '2015-12-13', '1001'), ('E16', 'Hennie', 'Mathew',
Full content available after purchase or with an active subscription.
Related Products
Related Products
MIS 548 Module 1 Knowledge Check 1; Artificial Intelligence Concepts, Drivers, Major Technologies, and Busi - Answers
MIS 548 Module 1 Knowledge Check 2; Nature of Data, Statistical Modeling, and Visualization - Answers
MIS 548 Module 2 Knowledge Check 1; Data Mining Process, Methods, and Algorithms - Answers
MIS 548 Module 2 Knowledge Check 2; Machine-Learning Techniques for Predictive Analytics - Answers
MIS 548 Module 3 Knowledge Check 1; Deep learing and cognitive computing - Answers
MIS 548 Module 3 Knowledge Check 2; Text Mining, Sentiment Analysis, and Social Analytics - Answers
MIS 548 Module 4 Knowledge Check 1; Prescriptive Analytics Optimization and Simulation - Answers
MIS 548 Module 5 Knowledge Check 1; Robotics Industrial and Consumer Applications - Answers
MIS 548 Module 5 Knowledge Check 2; The Internet of Things as a Platform for Intelligent Applications - Answers
MIS 548 Module 6 Knowledge Check 1; Group Decision-Making, Collaborative Systems, and AI Support - Answers
MIS 548 Module 6 Knowledge Check 2; Knowledge Systems Expert Systems, Recommenders, Chatbots, Virtual Privacy - Answers
MIS 548 Module 7 Knowledge Check; Implementation Issues From Ethics and Privacy to Organizational and Society - Answers
MIS 582 Module 1 - Lesson 1; Knowledge Check
MIS 582 Module 1 - Lesson 2; Knowledge Check
MIS 582 Module 2 Case Study Assignment; Impulse Logic and Oracle Cloud Infrastructure A Modern Database Analysis
MIS 582 Module 2 Discussion; Technical Case Study
MIS 582 Module 3 Case Study Assignment; Loyal improves data protection, platform performance with Always Encrypted with secure enclaves for Azure SQL Database
MIS 582 Module 7 Post-Assessment; Applied AI for Business (Due Week 8)
MIS 582 Week 3 Course Project; SQL Queries and Screenshots
MIS 582 Week 4 Course Project; Database Relationships and ERD Creation
MIS 582 Week 5 Course Project; SQL Table Structure & Queries.
MIS 582 Week 6 Course Project; SQL 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.