CBSE Class 12 Sample Paper for 2023 Boards

CBSE Class 12 Sample Paper for 2022 Boards [Term 2] - Computer Science →
Computer Science - Class 12
Solutions to CBSE Sample Paper - Computer Science Class 12

Question 34 (i) - CBSE Class 12 Sample Paper for 2023 Boards - Solutions to CBSE Sample Paper - Computer Science Class 12

Last updated at April 16, 2024 by

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.

 

ROLL_NO SNAME SEM1 SEM2 SEM3  DIVISION
101 KARAN 366 410 402 I
102 NAMAN 300 350 325 I
103 ISHA 400 410 415 I
104 RENU 350 357 415 I
105 ARPIT 100 75 178 IV
106 SABINA 100 205 217 II
107 NEELAM 470 450 471 I

Based on the data given above answer the following questions:

(i) Identify the most appropriate column, which can be considered as Primary key.

 

Answer:

A primary key is an attribute which can uniquely identify the records in a relation/table.

In the given table, the column ROLL_NO can uniquely identify each record.

Therefore, ROLL_NO is the most appropriate column to be considered as the primary key.

Go Ad-free
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo