from the hospital’s archaic mainframe system. The system is populated primarily by human typing, so the potential for human input error is extremely high in the provided data dump. Unfortunately, this mainframe contains no business logic to prevent human error.
As a consultant, you have been asked to provide detailed recommendations for the problems below. Your job as an informatics consultant is to organize the data and make some logical conclusions and present them to the Board of Trustees. The Board is primarily interested in well rooted conclusions backed up by sound data.
By the way, you are competing against other firms as well; the team with the best recommendations will get the contract to implement the proposed solutions. Use logic and interpretation to create and frame your explanations.
The hospital is looking to re-organize their database in to a relational manner, but do not know how to break it out or group the relationships. What would the new tables look like? How would they be joined together? Unique ID columns will more than likely need to be created.
You are requested to prepare an executive report and a presentation; both to be delivered to the board of trustees of the hospital. Your report and presentation should include the following:
It is up to the you to organize the report and the presentation, however all elements indicated in the items above should be included in the final report. You may choose to include technical documents as appendices or include in the main body of your presentation/report. Just make sure to remember your target audience (board of trustees). All of this analysis you have done becomes valuable if it is presented in a manner that will captivate their attention. Your summary is expected to be professional and data visualization is key to capturing the executive’s attention. On the other hand, they would like technical details to be included in your report and presentation, in case they feel the need to get your claims verified. The primary purpose of the presentation is to convince the board that you are the right team for the job. The secondary purpose of the presentation is to get feedback from the instructor.
The submissions should include the presentation in ppt, pptx, or pdf format; all SQL scripts in sql format (SQL files must include appropriate comments and be appropriately referenced by file name in presentation/report); all other submissions (including the final report) should be in pdf format.
Hi there! Click one of our representatives below and we will get back to you as soon as possible.