Navdeep creates a table RESULT with a set of records to maintain the marks secured by students in Sem 1, Sem2, Sem3 and their division. After creation of the table, he has entered data of 7 students in the table.
Based on the data given above answer the following questions:
(i) Identify the most appropriate column, which can be considered as Primary key.
(ii) If two columns are added and 2 rows are deleted from the table result, what will be the new degree and cardinality of the above table?
(iii) Write the statements to:
a. Insert the following record into the table Roll No- 108, Name- Aadit, Sem1- 470, Sem2-444, Sem3- 475, Div – I.
b. Increase the SEM2 marks of the students by 3% whose name begins with ‘N’.