-- create

CREATE TABLE EMPLOYEE ( Emp_NO INTEGER PRIMARY KEY, Emp_Name TEXT NOT NULL, Emp_Add TEXT NOT NULL, Emp_Phone TEXT NOT NULL, Dept_No TEXT NOT NULL, Dept_Name TEXT NOT NULL, Salary TEXT NOT NULL );

-- insert

INSERT INTO EMPLOYEE VALUES (0001, 'Ramesh', 'GNoida','9855498465', '3445', 'Sales','25000'); INSERT INTO EMPLOYEE VALUES (0002, 'Suresh', 'GNoida','98565498465', '0072', 'Sales','75000'); INSERT INTO EMPLOYEE VALUES (0003, 'Rajesh', 'GNoida','9855497865', '2324', 'Sales','28000'); INSERT INTO EMPLOYEE VALUES (0004, 'Shyamu', 'BSB','9853698465', '8883', 'Sales','35000'); INSERT INTO EMPLOYEE VALUES (0005, 'Ramu', 'BSB','9855498235', '74568', 'Sales','96000'); INSERT INTO EMPLOYEE VALUES (0006, 'Mahesh', 'GNoida','9851678465', '1238', 'Sales','25000'); INSERT INTO EMPLOYEE VALUES (0007, 'Chaman', 'BSBS','9856723465', '7634', 'D10','215000');