Question

Please help me solve this question?!​

Answer 1

The table name is not visible so, it mentioned as <Table name> in the answers to the query. Kindly fill the table table name in place of

<Table name>.

Ans 1. alter table <Table name> add primary key (Department);

Ans 2. insert into <Table name> values('H606','Cardiology','TTS','Vinita Wahi');

Hope this will help you.

encourage me by voting 5 star and a thanks.

Thank you!

Answer 2

1. ID can be set as the primary key as ID is unique to every doctor.

Or in other words every doctor has a unique ID.

2. INSERT INTO (Tablename) (“ID”, “Department “, “OPD_Days”, “Doctor_Name”) Values (‘ H608’, ‘Cardiology ‘, ‘TTS’, ‘Vinita Wahl’);

3. Select * from (tablename) where OPD_ DAYS= ‘MWF’ ;