Question

consider the following table and answer the following :
ID Department OPD_DAYS Doctor_Name
H201 ENT MWF Akaash Arora
H308 Oncology TTS Dharma Sharma
H907 Paediatrics MWF Sanjay Singh
(a)

Identify suitable Primary Key from the above table.
(b)

Add a new record with the following data :
(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)
(c)

Write a select query to display records of those Doctors whose OPD_DAYS are
‘MWF’. ​

Answer 1

Answer:

consider the following table and answer the following :

ID Department OPD_DAYS Doctor_Name

H201 ENT MWF Akaash Arora

H308 Oncology TTS Dharma Sharma

H907 Paediatrics MWF Sanjay Singh

(a)

Identify suitable Primary Key from the above table.

(b)

Add a new record with the following data :

(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)

(c)

Write a select query to display records of those Doctors whose OPD_DAYS are

‘MWF’.

Explanation:

consider the following table and answer the following :

ID Department OPD_DAYS Doctor_Name

H201 ENT MWF Akaash Arora

H308 Oncology TTS Dharma Sharma

H907 Paediatrics MWF Sanjay Singh

(a)

Identify suitable Primary Key from the above table.

(b)

Add a new record with the following data :

(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)

(c)

Write a select query to display records of those Doctors whose OPD_DAYS are

‘MWF’.