(Solved): 1. Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors, be ...

1. Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors, beds in different wards. Associate with each patient a log of the various tests and examinations conducted, if patient is admitted keep record accordingly. a. Construct E-R diagram for hospital b. Design schema for hospital c. Necessary SQL command for different reports of tests, bill, doctor's prescription and admission information.