Course Solutions Uncategorized (Solved) : Drop Table Department Purge Drop Table Employee Purge Create Table Department Id Departmen Q33422569 . . . .

(Solved) : Drop Table Department Purge Drop Table Employee Purge Create Table Department Id Departmen Q33422569 . . . .

 

drop table department purge; drop table employee purge; create table department (ID, department_name) as select deptno, dname from dept; create table employee (employee_id, dept_id) as select empno, deptno from emp; alter table department modify id NULL alter table employee modify employee id NULL alter table employee modify dept_id NULL;

1. Add a table level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be enabled at creation Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be enabled at creation. Add a foreign key 

<div class=

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post