Question

3. Create a table Hospital with the fields

(doctorid,doctorname,department.qualification,experience).

Write the queries to perform the following.

a) Insert 5 records

b) Display the details of Doctors

c) Display the details of doctors who

have the qualification 'MD'

d) Display all doctors who have more than 5 years experience but do not have

qualification 'MD'

e) Display the doctors in 'Skin' department

f) update the experience of doctor with doctored='D003' to 5

g) Delete the doctor with DoctorID='D005"

Answer 1

Explanation:

Microsoft Excel is a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis.