Given an instance of the EMPLOYEES relation as shown below:
|
E_ID |
E_Name |
E_Age |
E_Mail |
Salary_in_Lakhs |
|
XE005 |
Nitesh |
24 |
nitestSE@123 |
9 |
|
XE010 |
Vishnu |
27 |
vishnu.MG@123 |
10 |
|
XE007 |
Arya |
23 |
arya.TET@07 |
8 |
|
XE003 |
Satya |
28 |
satyaME@01 |
11 |
|
XE023 |
Nitesh |
24 |
nitestCE@123 |
R |
|
XE012 |
Vipul |
24 |
vipul@321 |
9.5 |
For this instance (E_Name, Salary_in_Lakhs) is the primary key, the value R should not be equal to _____
(E_Name, Salary_in_Lakhs) is the key
(E_Name, Salary_in_Lakhs) → {E_ID, E_Age, E_mail}
E_Name: Nitesh is repeated
Check only for Nitesh
(Nitesh, 9) → (XE005, 24, nitestSE@123)
(Nitesh, R) → (XE023, 24, nitestCE@123)
Since right hand side is not same
Therefore, R cannot be equal to 9
If R is equal to 9 then (E_Name, Salary_in_Lakhs) is not a key.



