I need a hospital design database tables based of the information below

A patient will have unique Patient ID. Full description about the patient about personal detail and phone number, and then Disease and what treatment is going on. The doctor will handle patients, One doctor can Treat more than 1 patient. Also, each doctor will have unique ID. Doctor and Patients will be related. Patients can be admitted to hospital. So different room numbers will be there, also rooms for Operation Theaters and ICU. There are some nurses, and ward boys for the maintenance of hospital and for patient take care. Based upon the number of days and treatment bill will be generated.

List all Identified Tables at least 5 to 7 tables

o List all fields with attributes of each table

o Include Primary and foreign keys