Saturday, June 6, 2020

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 )