Assignment 3 Note:
Tables referred in this assignment are same as that ofAssignment 2.
1. For each table, append your student id along with the tablename. For e.g. employee_student id (employee_T16363737)
2. Format for questions: a. Question: b. SQL statement solutionc. Screenshot for correct input d. Screenshot for violation (ifany)
Q1) Check the structure of tables.
Q2) Check the constraint name for applied constraints?
Q3) Drop the unique constraint on ENAME
Q4) Drop the Foreign Key constraint on DEPTNO
Q5) Add Foreign Key constraint on DEPTNO
Q6) Change Data type of ENAME. (If previously you have marked itas VARCHAR 2, then make it CHAR or vice versa)
Q7) Change width of DNAME ( For e.g. If you have defined it’ssize has 20 then make it 30)
Q8) Add COMM column in EMP table
Q9) Drop CITY column from S table
Q10) Create duplicate copy of EMP table
Q11) Copy structure of DEPT table in another table withdifferent column names
Q12) Change the name and job of the employee whose EMPNO=100
Q13) Delete the record of employee who belong to computerdepartment
Q14) Drop DEPT Table
Q15) Drop duplicate table of EMP table
