B2. Consider the following SQL query in the STUDENT relation. SELECT SNO FROM STUDENT WHERE (CR_HOURS > 12 OR MAJOR != “DATABASE”) AND DNAME = “IT” AND (MAJOR = “DATABASE” OR CR_HOURS > 12); a....

B2. Consider the following SQL query in the STUDENT relation.
SELECT SNO FROM STUDENT
WHERE (CR_HOURS > 12 OR MAJOR != “DATABASE”)
AND DNAME = “IT”
AND (MAJOR = “DATABASE” OR CR_HOURS > 12);

a. Simplify the query using idempotency rules

b. Draw the relational algebra tree for the above-simplified query.