Introducation to Database

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

Use Joins to write a query to retrieve all rows in the EMPLOYEES table, even if there is no match in the DEPARTMENTS table. Which join would you use and why?

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)