Topic : Intro to Database

Populate the table with sample data (at least 4 records) In the following format. While populating table keep in mind the constraints.

Manipulate the data to delete the employee with salary less than average salary

INSERT INTO EMPLOYEE VALUES(John', 'B', 'Smith, 123456789','9-Jan-55","731 Fondren, Houston, TX', 'M',3eeee, '987654321,5); INSERT INTO EMPLOYEE VALUES ('James', 'E', 'Borg, 888665555, 10-Nov-27', '450 Stone, Houston, TX', 'M', 55800, NULL, 1); insert into DEPARTMENT values ("Headquarters', 1, 888665555, 19-Jun-71'); '1, *-" INSERT INTO DEPENDENT VALUES (123456789, 'Alice', 'F', '31-Dec-78", "Daughter); ''F'" INSERT INTO PROJECT VALUES ('Productx', 1, 'Bellaire', 5); INSERT INTO WORKS_ON VALUES (123456789, 1. 32.5)