1. As HIM director of a healthcare system, you have been appointed to a team of individuals to develop a rationale for a Data Governance (DG) program. In one of the first team meetings the agenda is to discuss and develop a list of key factors for DG program success and explain why each is critical for achieving a viable DG program.

 a. Create the supporting document that will be presented at an Executive meeting to help the CEO and other executives decide about how to structure the DG program. (25 points)

 2.  Many hospitals need to track trends about patient outcomes to improve healthcare delivery. However, they often lack the tools necessary to achieve that goal. At University Hospital, the database management systems (DBMS) administrator is responsible for creating and maintaining databases. Several departments have asked him to develop real-time analytics and visualizations to track patient trends. These real-time analytics and visualizations would be based on standard simple queries. They also want to keep track of all the data they document and have had trouble creating a system that is modeled well for easy access.

a.  Evaluate if the DBMS administrator should choose a NoSQL database or a relational database for real-time analytics and visualization?

b. For the system the database administrator must build to track all the data University Hospital documents, what are the database design steps the database administrator should follow to ensure the information is organized and stored for easy access? Please describe each step.