CREATE SCHEMA TEST;

CREATE TABLE System_Builder
(Emp_ID				INTEGER 				NOT NULL 	UNIQUE,
 Emp_Name		VARCHAR(30)		NOT NULL,
 Job_Role			VARCHAR(20)		NOT NULL,
 Hourly_Wage		INTEGER				NOT NULL,
 Contact_NUM	VARCHAR(10)		NOT NULL,
 PRIMARY KEY (EMP_ID));

 CREATE TABLE Completed_Systems
(Order_ID			INTEGER 				NOT NULL 	UNIQUE,
 Configuration		VARCHAR(30)		NOT NULL,
 Builder_ID			INTEGER				NOT NULL,
 PRIMARY KEY (Order_ID),
 FOREIGN KEY (Builder_ID) REFERENCES System_Builder(EMP_ID));

 INSERT INTO System_Builder
 VALUES(1, 'Ashraff', 'Senior Technician', 100, 0774951414),
				(2, 'Muditha', 'Senior Technician', 100, 0768374757),
                (3, 'Rukshan', 'Senior Technician', 100, 0773502276),
                (4, 'Shabir', 'Technician', 75, 0777708861),
                (5, 'Deeban', 'Technician', 65, 0777117864);

 INSERT INTO Completed_Systems
 VALUES(1, 'BLACKBOX', 1),
				(2, 'RLG', 4),
                (3, 'BLACKBOX WORKS', 3),
                (4, 'RLG PREM', 2),
                (5,  'CUSTOM', 1);