Database design and optimization

HSP is a hospital employing doctors, nurses and medical research lab technicians. It includes a number of departments, research labs, and rooms. HSP welcomes patients who are checked up by the concerned doctors, and admitted in the hospital if necessary. A decision has been made to implement a centralised database for HSP in the best possible time. You, the data analyst, have been assigned with the task to analyse the data requirements of HSP, and propose, design and build a new MySQL database to service the needs of HSP. Tasks Design and implement MySQL database based on an analysis of the following data: