Question

consider the following table 'Student Record" and answer the following:
Admn. No.
Class
Roll No.
Students Naine
Class Incharge
1164
VII
Anita
Yash
VIII
1204
Laghay
Neena
1908
Antall
VII
19
Anita
2001
Nitin
IX
10
Parul
Rohan
2012
Parul
19
Identify suitable primary key from the above table. D an No
ii) Add a New : ecord with the following data :
('1864', '6', 'VIII', 'Meena', 'Riya')
II) Write a select query to display record of class whose Incharge is Perul.
​

Answer 1

Answer:1)primary key= Adm. No.

2)insert into "student record"

Set('Adm.no.','class','roll no.','students name','class incharge')

Values('1864','6','VIII','Meena','Riya');

3)select*

from"students record"

Where 'class incharge'='parul';

Explanation: