Consider the following table structures related to a university for the below questions. EMPLOYEE

NAME	VARCHAR(30)	NOT NULL
EID	VARCHAR(10)	NOT NULL
DEPTNO	INT(5)	NOT NULL
HODEID	VARCHAR(10)
SALARY	INT(10)

PRIMARY KEY (EID), FOREIGN KEY (HODEID) REFERENCES EMPLOYEE (EID), FOREIGN KEY (DEPTNO) REFERENCES DEPARTMENT (DID); DEPARTMENT

DID	INT(5)	NOT NULL
DNAME	VARCHAR(30)	NOT NULL
HODID	VARCHAR(10)	NOT NULL
HODNAME	VARCHAR(30)

PRIMARY KEY (DID), UNIQUE (DNAME), FOREIGN KEY (HODID) REFERENCES EMPLOYEE (EID); PROJECT WORK

EMPID	VARCHAR(10)	NOT NULL
PROJNO	INT(5)	NOT NULL
PROJECTLOC	VARCHAR(30)	NOT NULL

PRIMARY KEY (EMPID, PROJNO), FOREIGN KEY (EMPID) REFERENCES EMPLOYEE (EID);

Refer table structures given above. The university decided to give all employees in the 'SCIENCE' department a $20\%$ rise in salary. Which of the following query or queries will compute the above results?

(A)
UPDATE EMPLOYEE
SET SALARY = SALARY * 1.20
WHERE DEPTNO IN (SELECT DID FROM DEPARTMENT WHERE DNAME='SCIENCE');

(B)
UPDATE TABLE EMPLOYEE
SET SALARY = SALARY * 1.20
WHERE DNAME='SCIENCE';

(C)
ALTER TABLE EMPLOYEE
SET SALARY = SALARY * 1.20
WHERE DEPTNO IN (SELECT DNAME FROM DEPARTMENT WHERE DNAME='SCIENCE');

Choose the correct answer from the options given below: