2. You are assigned to design a Hospital Management System for Klang Valley Medical Centre. The following are requirements of the system: There are three types of employees in this hospital which are the physician (medical doctor), nurse and administrator. Unlike administrative staff, a physician and a nurse staff have special attributes. A physician has a qualification and an expert area. A nurse has a position and a ward_id where he or she is placed. A physician treats many patients and a patient can be treated by more than one physician. Each treatment has prescriptions. The prescription has a prescription_id, date, product_code, dosage and amount. A patient can be placed in a ward. A ward is serviced by several nurse staff. The ward information includes ward number, building, ward_type and a number of beds. List all entities with their attributes. Identify the primary key. (a) (b) Draw an Entity Relationship (ER) diagram to represent the given information. (8) (12) (Total : 20)