Monday, July 14, 2025

 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);