Consider the relation Emp-Dept with SSn as key: Ename | SSn | EAddr | Dept. No…
PYQ KVS TGT/PGT 2018
Consider the relation Emp-Dept with SSn as key:
Ename | SSn | EAddr | Dept. No | Dept. Name | Dept. Manager SSn
Which of the following is (are) invalid operation(s)?
(i) Inserting an employee without name and address.
(ii) Inserting an employee with only SSn.
(iii) Inserting a department with no employee.
(iv) Inserting an employee without SSn.
- A.
(i) only
- B.
(iv) only
- C.
(iii) and (iv)
- D.
(ii) and (iii)
Attempted by 326 students.
Sign up free to check your answer
Sign up freeLoading lesson…

