10. Retrieve SSN and department name for all employees.(COMPANY DATABASE NAVATHE BOOK)

10. Retrieve SSN and department name for all employees.(COMPANY DATABASE NAVATHE BOOK)

9. Retrieve the names of all employees who do not have supervisors(COMPANY DATABASE NAVATHE BOOK)

9. Retrieve the names of all employees who do not have supervisors(COMPANY DATABASE NAVATHE BOOK)

8. Retrieve all employees in department 5 whose salary is between 50,000 and 60,000(inclusive)(COMPANY DATABASE NAVATHE BOOK)

8. Retrieve all employees in department 5 whose salary is between 50,000 and 60,000(inclusive)(COMPANY DATABASE NAVATHE BOOK)

7. Retrieve all employees who were born during the 1950s.(COMPANY DATABASE NAVATHE BOOK)

7. Retrieve all employees who were born during the 1950s.(COMPANY DATABASE NAVATHE BOOK)

6. Retrieve all employee names whose address is in „Bellaire‟(COMPANY DATABASE NAVATHE BOOK)

6. Retrieve all employee names whose address is in „Bellaire‟(COMPANY DATABASE NAVATHE BOOK)

5. Retrieve all distinct salary values. (COMPANY DATABASE NAVATHE BOOK)

5. Retrieve all distinct salary values. (COMPANY DATABASE NAVATHE BOOK)

4. Retrieve the name and salary of every employee.(COMPANY DATABASE NAVATHE BOOK)

4. Retrieve the name and salary of every employee.(COMPANY DATABASE NAVATHE BOOK)

3. Retrieve the birthdate and address of the employee whose name is 'Franklin T. Wong'(COMPANY DATABASE NAVATHE BOOK)

3. Retrieve the birthdate and address of the employee whose name is 'Franklin T. Wong'(COMPANY DATABASE NAVATHE BOOK)

2. Display ssn, lname, fname, address of employees who work in department no 7. (COMPANY DATABASE NAVATHE BOOK)

2. Display ssn, lname, fname, address of employees who work in department no 7. (COMPANY DATABASE NAVATHE BOOK)

1. Display all the details of all employees working in the company. (COMPANY DATABASE NAVATHE BOOK)

1. Display all the details of all employees working in the company. (COMPANY DATABASE NAVATHE BOOK)

DEPENDENT TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)

DEPENDENT TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)

WORKSON TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK )

WORKSON TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK )

DEPT_LOCATION TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)

DEPT_LOCATION TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)

PROJECT TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)

PROJECT TABLE DATA INSERTION (COMPANY DATABASE NAVATHE BOOK)

EMPLOYEE TABLE DATA INSERTION ( COMPANY DATABASE NAVATHE BOOK)

EMPLOYEE TABLE DATA INSERTION ( COMPANY DATABASE NAVATHE BOOK)

1. 1ST PART

2 . 2ND PART

DATA INSERTION COMPANY DATABASE NAVATHE BOOK

DATA INSERTION IN  TABLE :

1.  DEPARTMENT --  CLICK

2.  EMPLOYEE -- CLICK

3.  DEPT_LOCATIONS -- CLICK

4.  PROJECT -- CLICK

5. WORKS_ON -- CLICK

6. DEPENDENT --   CLICK

DEPARTMENT TABLE DATA INSERTION ( COMPANY DATABASE NAVATHE BOOK )

DEPARTMENT TABLE DATA INSERTION ( COMPANY DATABASE NAVATHE BOOK )

DEPENDENT TABLE CREATION:: ( NAVATHE BOOK DATABASE )

DEPENDENT TABLE CREATION:: ( NAVATHE BOOK DATABASE )

WORKS_ON TABLE CREATION:: ( NAVATHE BOOK DATABASE )

 WORKS_ON TABLE CREATION:: ( NAVATHE BOOK DATABASE )

DEPT_LOCATIONS TABLE CREATION:: ( NAVATHE BOOK DATABASE )

DEPT_LOCATIONS TABLE CREATION:: ( NAVATHE BOOK DATABASE )