Question

Table STUDENT
No
1
2
3
Name
Pankaj
Shalini
Sanjay
Sudha
Rakesh
Surya
Age
24
21
22
25
22
34
Department
Computer
History
Hindi
History
Hindi
Computer
Dateofadm
1997-01-10
1998-03-24
1996-12-12
1999-07-21
1997-09-05
1997-02-05
Fees
120
200
300
400
Gender
M
F
M
F
M
M M
6
210
(a) Write a query to display all records.
(b) Add a new record with the following data:
(-8','Shikha','23', 'Hindi', '1997-07-31', '200','F')
(e) Write a select query to display records of those Students whose Department are
"History
(d) Write a query to display the names of all female students who are in Hindi
department
(e) Identify suitable primary key from the above table.​

Answer 1

Answer:

And the first thing that I will go is

Answer 2

Answer:

heubsksnjsjsjsjeiowkwbshbs sksn