Question

create emp and dept table with data

Answer 1

Create the EMP table which has a foreign key reference to the DEPT table. The foreign key will require that the DEPTNO in the EMP table exist in the DEPTNO column in the DEPT table. Insert row into DEPT table using named columns. Insert a row into DEPT table by column position.