USE [ORGANIZATION]
GO

TRUNCATE TABLE MASTER_DATA.DEPARTMENT
GO

INSERT INTO MASTER_DATA.DEPARTMENT VALUES
	('D001','HUMAN RESOURCE'),
	('D002','PAYROLL'),
	('D003','MARKETING'),	
	('D004','INVENTORY');
GO

INSERT INTO MASTER_DATA.DEPARTMENT VALUES
	('D005','MARKETING');
GO

TRUNCATE TABLE MASTER_DATA.EMPLOYEE
GO

INSERT INTO MASTER_DATA.EMPLOYEE VALUES
	('D001','E001','JOHN','SMITH'),
	('D001','E002','MARY','SMITH'),
	('D001','E003','SUSAN','GREEN'),	
	('D001','E004','JOHN','MARONE'),

	('D002','E005','TOM','DARBY'),
	('D002','E006','MARY','YORK'),
	('D002','E007','DEBBIE','MCDONALD'),	
	('D002','E008','GIOVANNI','BERTONE'),

	('D003','E009','LARRY','JONES'),
	('D003','E010','MIKE','MCGEE'),
	('D003','E011','BORIS','GOLD'),	
	('D003','E012','BERTHA','SMITH'),

	('D004','E013','DONALD','DILBY'),
	('D004','E014','JAKE','DORITO'),
	('D004','E015','THELMA','PINSKY');	
GO	


INSERT INTO MASTER_DATA.EMPLOYEE VALUES
	('D091','E016','JOHN','BARRY'),
	('D009','E017','BARRY','SMITH'),
	('D099','E018','MARY','GREEN');
GO

/*******************************/
/* Let's create some test data */
/*******************************/

DROP TABLE IF EXISTS MASTER_DATA.COURSE 
GO

CREATE TABLE MASTER_DATA.COURSE 
(
COURSE_ID VARCHAR(8) NOT NULL,
COURSE_NAME VARCHAR(32) NOT NULL
)
GO

INSERT INTO MASTER_DATA.COURSE VALUES
	('C001','MARKETING BASICS'),
	('C002','ACCOUNTING 1'),
	('C003','ACCOUNTING 2'),
	('C004','BOOK KEEPING FOR BEGGINERS');
GO

SELECT *
FROM [MASTER_DATA].[COURSE]
GO

TRUNCATE TABLE MASTER_DATA.EMPLOYEE
GO

INSERT INTO MASTER_DATA.EMPLOYEE VALUES
	('D001','E001','JOHN','SMITH'),
	('D001','E002','MARY','SMITH'),
	('D001','E003','SUSAN','GREEN'),	
	('D001','E004','JOHN','MARONE'),

	('D002','E005','TOM','DARBY'),
	('D002','E006','MARY','YORK'),
	('D002','E007','DEBBIE','MCDONALD'),	
	('D002','E008','GIOVANNI','BERTONE'),

	('D003','E009','LARRY','JONES'),
	('D003','E010','MIKE','MCGEE'),
	('D003','E011','BORIS','GOLD'),	
	('D003','E012','BERTHA','SMITH'),

	('D004','E013','DONALD','DILBY'),
	('D004','E014','JAKE','DORITO'),
	('D004','E015','THELMA','PINSKY');	
GO	

INSERT INTO MASTER_DATA.EMPLOYEE VALUES
	('D091','E016','JOHN','BARRY'),
	('D009','E017','BARRY','SMITH'),
	('D009','E018','MARY','GREEN');
GO

TRUNCATE TABLE MASTER_DATA.COURSE
GO

INSERT INTO MASTER_DATA.COURSE VALUES
	('C001','MARKETING BASICS'),
	('C002','ACCOUNTING 1'),
	('C003','ACCOUNTING 2'),
	('C004','BOOKING FOR BEGGINERS'); -- error on purpose
GO