Assignment 1 10 marks Consider a hospital information system with the following characteristics A patient can either be a resident who is admitted to the hospital or an outpatient who comes to the hospital for an outpatient clinic For both types of patients we will need to hold the patients name telephone number address date of birth and the patients family doctor GP For a resident patient we will need to hold the ward name in which the patient is currently residing the admission date of the patient and also information about any operations that the patient has had The operation information will have to include the date and time of the operation the doctor assume one who carried out the operation plus the theatre where the operation took place For both GPs and hospital doctors we will need to hold the doctors name and telephone number in addition we will need to hold the GPs address and the hospital doctors specialism code for example he or she may specialize in ENT problems relating to ear nose and throat assume one per hospital doctor For outpatients we will need to hold information about the outpatients appointments the appointment date and time and the hospital doctor who attended to the patient Study the case given above and draw a complete entityrelationship diagram ERD Hint Decomposing any manytomany relationships indicate constraints eg unique identifier arcs etc make any assumptions that you need to make about optionalmandatory relationships and write description to support your design Include assumption if any Note You are required to draw ERD using crowfoot notation