Question

d) Find the value
the following function.
=SUM CA3,5, 91,21)
= COUNT (34,23,76,12,9,22)
​

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’.