INSERT INTO company VALUES
('SBI', 'MG Road'),
('SBT', 'MG Road'),
('Federal', 'Broadway'),
('Indian Bank', 'Cochin'),
('SIB', 'Ernakulam'),
('HDFC', 'Palace Road'),
('Axis', 'Cochin'),
('City bank', 'Ernakulam');
INSERT INTO emp VALUES
('E-101', 'Adarsh', 101, 'MG Road'),
('E-102', 'Bonny', 101, 'MG Road'),
('E-103', 'Catherine', 102, 'Cochin'),
('E-104', 'Glenn', 104, 'Ernakulam'),
('E-105', 'George', 201, 'MG Road'),
('E-106', 'Hayes', 101, 'MG Road'),
('E-107', 'Johnson', 102, 'Cochin'),
('E-108', 'Jones', 101, 'Cochin'),
('E-109', 'Karthik', 101, 'Ernakulam'),
('E-110', 'Lavanya', 101, 'Palace Road'),
('E-111', 'Niharika', 102, 'Ernakulam');
INSERT INTO works VALUES
('E-101', 'SBI', 71000),
('E-102', 'SBI', 90000),
('E-103', 'SBT', 40000),
('E-104', 'Federal', 37000),
('E-105', 'SBT', 17000),
('E-106', 'Indian Bank', 30000),
('E-107', 'SIB', 21000),
('E-108', 'SIB', 18000),
('E-109', 'Indian Bank', 28000),
('E-110', 'SBT', 250000),
('E-111', 'Federal', 40000);
INSERT INTO manages VALUES
('E-101', 'E-102'),
('E-102', NULL),
('E-103', 'E-110'),
('E-104', 'E-111'),
('E-105', 'E-110'),
('E-106', 'E-109'),
('E-107', NULL),
('E-108', NULL),
('E-109', NULL),
('E-110', NULL),
('E-111', NULL);