Hierarchy and relationships of the components in the use of databases Specific i

Question

Hierarchy and relationships of the components in the use of databases

Specific instructions:

In this task you will analyze the case of Mountain View Community Hospital . You will apply the knowledge of the hierarchy of data, as well as that of the relationships of the components in the use of the databases. The analysis must be presented in a very well defined and delimited way. The information must be relevant and documented. You will use the following questions as a guide: Could a well-managed database help the hospital to fulfill its mission? How can Mountain View Community Hospital use database technology to comply with the Health Insurance Portability and Accountability Act (HIPAA) of 1996 ? What are some of the costs and risks of using databases that the hospital must handle with care? How could the hospital use web-based applications?

Introduction This case is included to provide you an opportunity to apply case can also be used to support a semester-long database proj ect built throughout the term that results in a complete applica tion. We have selected a hospital for this case because it is a type of organization that is at least somewhat familiar to most per sons and because health-care institutions are of such impor tance in our society today. A segment of the case is included at the end of each chapter in this text. Each segment includes a chapter followed by questions and exercises related to the mate rial. Additional requirements, assignments, and project deliver ables a re provided in support of a semester project. Case Description Mountain View Community Hospital (MVCH) is a not-for-profit short-term, acute care general hospital. It is a relatively small hos- strives to meet the needs of a community of about 60,000 with an annual growth rate of 10 percent, a trend that is expected to con- serve the health-care needs of this growing community, Mountain View Community Hospital plans to expand its capacity by adding another 50 beds over the next five years, and opening a managed living facilities. The basic goal is to provide high-quality, cost compassionate, caring, and personalized manner. Within the last fiscal year, the hospital performed more ogy procedures. During that time, the hospital had 9,192 admis- sions and 112,230 outpatient visits, brought 1,127 babies into the world, and performed 2,314 inpatient and 1,490 outpatient sur geries. Patients who receive outpatient surgeries do not remain in the hospital overnight. With an average of 2,340 patients a month, the emergency department experienced approximately 28,200 visits throughout the year. Approximately 30 percent of

Explanation / Answer

Database Model of Mountain View Hospital
-> There is a well-defined relationship established between the entities.
-> The database model is well organized, each functionality is being split into multiple entities.
-> The entities are in normalized form.

A well-managed database would help the hospital to fulfill its mission.
HIPPA is a US Act for protecting the confidentiality of Personal Health Information (PHI). HIPPA provides a set of measures and rules to protect the protected health information of a patient. The well defined and maintained database would help in achieving the mission of a hospital. There are many factors. Some of the factors that would affect mentioned below.
-> The patient information is being stored in the database. The information can be accessed anytime and anywhere.
-> It avoids the physical loss of patient records by maintaining e-record.
-> The information is securely encrypted.
-> It provides database constraints and stores the data in a specific format.
-> Allows data backup
-> Allows big data analytics
-> Ensures data integrity
-> Avoids data duplication
-> Can enforce security authentications and mechanisms
-> The auto auditing feature of Mountain view would help to find the process breach.
-> Reporting patient safety issues through audits and bots.

What are some of the costs and risks of using databases that the hospital must handle with care?
-> The data integrity is one of the main things the database should take care. For example, the encounter_id associated with another patient used by some other patient due to data integrity issues of the database would lead to a major patient safety issue.
-> Maintaining the confidentiality of the data is also one of the main challenges.
-> Hacking
-> Breaching
-> Phishing
-> Internal security breaches
-> Data Leak
-> Data purge after specific period time
-> Maintaining server
-> Backing up the data
-> Avoiding data duplication
-> protecting against SQL injection
are some of the challenges and risks they must take care.

How could the hospital use web-based applications?
-> The web-based applications should be accessed within the virtual box to avoid an external attack.
-> The website shouldn't be posted publicly.
-> Sessions and Cookies need to be handled properly.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.