Engineer Raja

  Assignment - 02 -- Create Project table CREATE TABLE Project (     pno NUMBER PRIMARY KEY ,     pname VARCHAR2 ( 50 ) NOT NULL ,     manager_no NUMBER ,     CONSTRAINT FK_Manager FOREIGN KEY ( manager_no ) REFERENCES Manager_details ( manager_no ) ) ;   -- Create Manager_details table CREATE TABLE Manager_details (     manager_no NUMBER PRIMARY KEY ,     manager_name VARCHAR2 ( 50 ) ) ;   INSERT INTO Manager_details ( manager_no , manager_name ) VALUES ( 101 , 'John Manager' ) ; INSERT INTO Manager_details ( manager_no , manager_name ) VALUES ( 102 , 'Jane Manager' ) ;   -- Ensure that the manager_no in Project references existing manager_no in Manager_details INSERT INTO Project ( pno , pname , manager_no ) VALUES ( 1 , 'Project A' , 101 ) ; INSERT INTO Project ( pno , pname , manager_no ) VALUES ( 2 , 'Project B' , 102 ) ; -- Try to insert a record with a non-existent manager_no, which will be restricted INS

Assignment - 04 -- Creating DEPTT table CREATE TABLE DEPTT (     DPTNO NUMBER PRIMARY KEY ,     DPTNAME VARCHAR2 ( 50 ) ,     LOCATION VARCHAR2 ( 50 ) ) ;   -- Creating EMPLOYEE table with foreign key reference to DEPTT table CREATE TABLE EMPLOYEE (     EMPNO NUMBER PRIMARY KEY ,     EMPNAME VARCHAR2 ( 50 ) ,     JOB VARCHAR2 ( 50 ) ,     DEPTNO NUMBER ,     SALARY NUMBER ( 10 , 2 ) ,     COMM NUMBER ( 10 , 2 ) ,     DOB DATE ,     MANAGER_NO NUMBER ,     HIRE_DATE DATE ,     CONSTRAINT FK_DEPTNO FOREIGN KEY ( DEPTNO ) REFERENCES DEPTT ( DPTNO ) ) ;   --Display all employees whose names have 'AM' or 'SH' in them. SELECT EMPNAME , JOB , SALARY FROM EMPLOYEE WHERE EMPNAME LIKE '%AM%' OR EMPNAME LIKE '%SH%' ;   --List EMPNAME, JOB, and SALARY for all who have a manager. SELECT EMPNAME , JOB , SALARY FROM EMPLOYEE WHERE MANAGER_NO IS NOT NULL ;   --Show EMPNAME and TOTAL remuneration of all employees. SELECT EMPNAME , SALARY