Question

In a database STUDENT, there is a table RESULT with the following contents.

              **Table:Result**

| REGNO | NAME | MARKS | SECTION | CLASS TEACHERADMNO | ADMNO |
| 10004 | Mohit | 90 | A | Mr. Nathani | Z101 |
| 10211. | Mukta | 85 | B | Mr. Gokhle | Z109 |
| 10923 | Mohit | 82 | B | Mr. Gokhle | Z120 |
| 10313 | Sana | 70 | A | Mr. Nathani | Z234 |

(i) Identify the attributes which can be chosen as Candidate keys in the table RESULT.

(ii) Write SQL Query to change the marks of Mukta to 95 in the table RESULT.

Answer 1

(i) REGNO and ADMNO can be chosen as candidate keys.

(ii) UPDATE RESULT SET MARKS = 95 WHERE NAME = 'Mukta' .