Q3 Consider the following query, Eliminate Redundancy from to it using idempotency rules (4). = SELECT Number FROM EMPLOYEETABLE WHERE TITLE = "Programmer" AND NOT(ProjectNumber="C1" OR ALLOCATION_NO=12) AND Project Number != "C1" AND ALLOCATION_NO=12 Note: You can take help from 226 and 227 page of the book Principles of Distributed Database Systems, Third Edition for solving the question no 3 Idempotency rules: 1. 2. pV p op 3. pAtrue Ap 4. pv false op 5. p^ false false 6. pVtrue true 7. p1 -pfalse 8. PV -p true 9. p1 (p1 V p2) + p1 10. p1 V(p1 ^ p2) p1