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 )

PROJECT TABLE CREATION:: ( NAVATHE BOOK DATABASE )

PROJECT TABLE CREATION:: ( NAVATHE BOOK DATABASE )

ALTER DEPARTMENT TABLE :: ( NAVATHE BOOK DATABASE )

ALTER DEPARTMENT TABLE :: ( NAVATHE BOOK DATABASE )

EMPLOYEE TABLE CREATION:: ( NAVATHE BOOK DATABASE )

EMPLOYEE TABLE CREATION:: ( NAVATHE BOOK DATABASE )

DEPARTMENT TABLE CREATION :: ( NAVATHE BOOK DATABASE )

DEPARTMENT TABLE CREATION :: ( NAVATHE BOOK DATABASE )

COMPANY DATABASE NAVATHE BOOK

COMPANY DATABASE NAVATHE BOOK

 CREATE TABLE :

1.  DEPARTMENT -- CLICK HERE   ALTER TABLE DEPARTMENT

2.  EMPLOYEE -- CLICK HERE

 

3.  DEPT_LOCATIONS -- CLICK HERE

4.  PROJECT --  CLICK HERE

5. WORKS_ON --  CLICK HERE

6. DEPENDENT --  CLICK HERE

                

RED BLACK TREE INSERTION STEP BY STEP EXPLANATION

RED BLACK TREE INSERTION STEP BY STEP EXPLANATION