CREATE TABLE EMPLOYEES (
EMP_ID BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(252),
DEPARTMENT VARCHAR(128),
SALARY BIGINT,
JOINED_ON TIMESTAMP,
PRIMARY KEY (EMP_ID)
);
CREATE TABLE ASSET_MNGT (
AM_ID BIGINT NOT NULL AUTO_INCREMENT,
EMP_ID BIGINT,
ASSET_NAME VARCHAR(128),
VENDOR VARCHAR(128),
PRIMARY KEY (AM_ID),
FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEES(EMP_ID)
);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (1, 'Nataraja G', 'Documentation', 10000, CURRENT_TIMESTAMP);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (2, 'Amar M', 'Entertainment', 12000, CURRENT_TIMESTAMP);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (3, 'Nagesh Y', 'Admin', 25000, CURRENT_TIMESTAMP);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (4, 'Vasu V', 'Security', 2500, CURRENT_TIMESTAMP);
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (1, 'Laptop', 'Apple');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (1, 'Mobile', 'Apple');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (1, 'LCD Monitor', 'HCL');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (2, 'Laptop', 'Apple');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (2, 'Mobile', 'Samsung');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (2, 'LCD Monitor', 'HCL');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (3, 'Laptop', 'Apple');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (3, 'Mobile', 'Samsung');
INSERT INTO ASSET_MNGT (EMP_ID, ASSET_NAME, VENDOR) VALUES (4, 'Laptop', 'Apple');
|