Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry 7369 Description Employee ID number Employee surname EMPNO ENAME SMITH Employee's job title No ID no. of...


Table EMP<br>Column name<br>Column type<br>Integer<br>Up to 10<br>characters<br>Integer<br>Integer<br>Example entry<br>7369<br>Description<br>Employee ID number<br>Employee surname<br>EMPNO<br>ENAME<br>SMITH<br>Employee's job title No<br>ID no. of employee's<br>manager<br>Date employment started<br>Monthly salary<br>JOBNO<br>10<br>MGR<br>7566<br>HIREDATE<br>Date<br>17/12/1980<br>SAL<br>Integer<br>1600<br>Table JOB<br>Column name<br>Column type<br>Integer<br>Up to 15<br>characters<br>Example entry<br>Description<br>job title No<br>Employee's job title<br>JOBNO<br>10<br>JОB TITLE<br>SALESMAN<br>c) Write SQL statements to define referential integrity constraints on EMP table and<br>give SQL examples to describe the different ways that referential integrity<br>constraints can cause the database system to behave when a user attempts to<br>update a table row. (Maximum 300 words).<br>

Extracted text: Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry 7369 Description Employee ID number Employee surname EMPNO ENAME SMITH Employee's job title No ID no. of employee's manager Date employment started Monthly salary JOBNO 10 MGR 7566 HIREDATE Date 17/12/1980 SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JОB TITLE SALESMAN c) Write SQL statements to define referential integrity constraints on EMP table and give SQL examples to describe the different ways that referential integrity constraints can cause the database system to behave when a user attempts to update a table row. (Maximum 300 words).

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here