Home / Expert Answers / Computer Science / write-a-query-in-sql-to-create-a-table-employee-and-department-employee-empno-ename-deptno-job-h-pa493

(Solved): Write a query in sql to create a table employee and department Employee(empno, ename, deptno, job, h ...



Write a query in sql to create a table employee and department Employee(empno, ename, deptno, job, hiredate, salary, mgrno, commission) Department(deptno, dname, loc) Include the following constraints on column of table. emp a) to make the empno as primary key of the table and b) to ensure that the ename column does not contain NULL values and add salary column with constraint greater than zero Include the following constraints on column of dept table. a) to make deptno as primary key. b) to ensure dname,loc coloumns does not contain NULL values Also enforce REFERENTIAL INTEGRITY declare deptno field of dept table as primary key and deptno field of emp table as foreign key



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe