Question

20. Consider the following table and answer the following:
ID
Department
Teaching - Days
T201
Science
MWS
T202
English BEFORE TTS
T203
Math
MWS
T204
Math
Teacher - Name
Amrita Kapoor
Radha Kansal
Bindu Singh
Faiz Abdul
in
MTW
Doctor-Info Table
a) Identify suitable Primary Key from the above table.
b) Add a new record with the following data: - Write the query
(*T205', 'Computer”, “TTS', 'Shalu Singh')
c) Write a select query to display records of those Teachers whose Department is Math'
d) Suggest a suitable datatype for the field “Teacher Name”.
e) Write a select query to display details of those teachers whose Teaching - Days is 'MWS'.

Answer 1

Answer:

off the phone with my family and friends of the day of the day of the day of the day and time for the day of your help in any way I can do to get you the Facebook Twitter Pinterest Instagram Twitter