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:

(a) ID

(b) insert "tablename" the values (H608,................

.......wahi);

(c)

Explanation:

select * from "tablename" of Doctors whose OPD DAYS=MWF

Answer 2

The answer for the above question is listed below :

a)Primary key is "ID".

b)insert into table_name values (‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’);

c)select * from table_name where OPD_DAYS IN ('MWF');

Explanation:

1. The primary key is a unique key that is used to identify the whole records. So the primary key in the above table is "ID".
2. The insert Query is used to insert the data on the table, but there is a needs to know the table name, So the user needs to write the table name on the place of "Table_name" in the above query.
3. The select query is used to select the data from the table, but there is a needs to know the table name, So the user needs to write the table name on the place of "Table_name" in the above query. The select query holds the In because "In" is used to search the content from the table.

Learn More :

• SQL : https://brainly.in/question/9086414