Mid-County Hospital holds data on doctors and patients in two tables in its database (see the following tables): DOCTOR and PATIENT.

Use your DBMS to build the appropriate schema, enter the records, and create the reports described in items a-c on the next page.

a. A report showing the following details for each doctor in this order: Last Name, First Name, and Ward. Arrange the report by ascending alphabetical order of the last names.

b. A report showing the entire record with the original order of columns of all the doctors whose salary is greater than 100,000 who work for one of the following wards: Internal (INT), Obstetric-Gynecological (OBG), Oncology (ONC).

c. A report showing the following details for all of Dr. Anderson’s patients: Dr. Anderson’s first name, last name, and Doctor’s ID, and ward (from the DOCTOR table) should appear once at the top of the report. Each record on the list should show the Patient’s Last Name, First Name, and Date of Admission (from the PATIENT table).