Mis602 Assign 3 Page 1 Of 4assessment Briefsubject Code And Titlemis6 ✓ Solved

MIS602 Assign 3 Page 1 of 4 ASSESSMENT BRIEF Subject Code and Title MIS602 Data Modelling & Database Design Assessment Reflective Research Report Individual/Group Individual Length Three Thousand Word Limit Learning Outcomes a, b, c, d Submission Friday 11:59 PM AEST/AEDT of Module 6.1 (week 11) Weighting 40% Total Marks 40 Marks Context: The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules.

The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment. Scenario: The scenario for this assessment is a multi-specialty hospital system, the Royal Rundle Hospital (RRH), that provides a broad range of services to the community which include surgical, maternity, obstetric care, dialysis, emergency, mental health, aged and palliative care, allied health services and a 24-hour emergency department.

The RRH has been serving in the region for over 50 years and has been using paper-based forms and documents to store and manage all the data with some use of spreadsheets that started not so long ago. Now that the management of RRH wants to take the advantages of Information Technology to maintain and manage the records of the various aspects of the hospital system more efficiently, they have put out a Request for Proposals (RFP) for appropriately qualified consultants to undertake a body of work that would help to scope the data requirements for such a system. With your success in your Torrens University Australia degree so far, and other similar projects that have garnered you some sustained success in the eyes of the profession and community, you have been shortlisted among no less than 10 other consultancies.

There are expectations from them, then, as to the standard of report you will produce. MIS602 Assign 3 Page 2 of 4 The management of the RRH has provided you with an overview and description of the hospital system as below- Overview: The Royal Rundle Hospital (RRH) is a multi-specialty hospital that includes a number of departments, rooms, doctors, nurses, compounders, and other staff working in the hospital. Patients having different kinds of ailments come to the hospital and get checkup done from the relevant doctors. If required they are admitted in the hospital and discharged after treatment. The hospital maintains the records of various departments, rooms, and doctors in the hospital besides the most important records of the regular patients, patients admitted in the hospital, the checkup of patients done by the doctors, the patients that have been operated, and patients discharged from the hospital.

Description: In RRH, there are many departments like Orthopedic, Pathology, Emergency, Dental, Gynecology, Anesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I., Neurology, Cardiology, Cancer Department, Corpse, etc. There is an OPD where patients come and get a card (that is, entry card of the patient) for check up from the relevant doctor. After making entry in the card, they go to the relevant doctor’s room and the doctor checks up their ailments. According to the ailments, the doctor either prescribes medicine or admits the patient in the relevant department. The patient may choose either private or general room according to his/her need.

But before getting admission in the hospital, the patient has to fulfill certain formalities of the hospital like room charges, etc. After the treatment is completed, the doctor discharges the patient. Before discharging from the hospital, the patient again has to complete certain formalities of the hospital like balance charges, test charges, operation charges (if any), blood charges, doctors’ charges, etc. Next, the management talks about the doctors of the hospital. There are two types of the doctors in the hospital, namely, regular doctors and call-on doctors.

Regular doctors are those doctors who come to the hospital daily. Call-on doctors are those doctors who are called by the hospital if the relevant regular doctor is not available. Instructions: The management believes and understands that the benefits of an IT solution to manage and maintain their records are enormous and hopes to gain a thorough insight that should come from a lot of forethought and design elements fed into it before it could be seriously considered by them. The RRH management seeks consultation on what the data requirements of such a system might be. There are two objectives of this assessment: 1.

For the purposes of the client, the Royal Rundle Hospital (RRH) management, you are to produce a design brief and, 2. For the purposes of the assessment, you are to produce a reflection. So, this written submission should expertly mix a consultative style—that is, providing a solution to the problem as outlined by the client—with a deep reflection on what you have learned in the MIS602 Assign 3 Page 3 of 4 subject and the potential for such an automated system. You will need to use your judgement on this, it is likely to take several drafts to get it right. The deliverable for this assessment is plainly: You are required to create a consultative report that addresses the data requirements of the proposed Royal Rundle Hospital (RRH) System as well as commenting on the feasibility of such a solution, given what you learned in the subject.

Following instructions will assist you in completion of the task. Some hints for you to heed while you develop and write your assessment: • Consider all aspects of the hospital’s operations and flows of data and then explore the benefits and challenges that an automated system may present in regard to effectiveness, efficiency an also adaptation issues, when implemented. • The RRH management has not provided any assumptions and you should list these if your proposal and reflection are to be considered cogent. Based on your learning from the course modules and previous assignments, you are expected to come up with data requirements and a logical design of the system and a brief commentary on the design.

Submission Instructions: This consultative research and reflective report will be in a format that you choose and there are no prescriptions for what to include or what not to include. You will need to research consultant-grade reports (look for consulting reports form the Big Four firms as a guide and use them as the basis for their content, articulation presentation standard). Besides your research and reflection, you should include logical data requirements in a design summary that includes appropriate Entity- Relationship (ER) Diagram replete with connectivity and cardinality considerations, and the database schema with the final set of Relations normalised to 3NF (Note: you do not need to include the normalisation steps).

You should list any and all assumptions used in your report as well as any limitations that the reader should consider as they read your report. You should treat the prescribed word limit as something you cannot breach as there is no plus-or- minus 10 per cent ascribed in this assessment. The reality of consultant-grade reports is that any that breach the requirements are rejected and no reasoning is provided to the consultant. As you are preparing for your professional life, treat this requirement as the same in this subject and that any report that breaches the word limit will not be marked. Requests for extensions must be compliant with the university policy and must be applied for before the due date.

Include in your application a full draft of your assessment as this draft may be what is assessed if the extension request is denied. Submit your report to the submission point in Blackboard prior to the due date. In accordance with university policy, late assessments will attract a 10% of available grade penalty for every day late, up to a maximum of 5 days, after which the assessment will not be marked. Please note that requests for resubmissions of this assessment will not be considered. Learning Rubric: Assessment Three Assessment Attributes Fail (Unacceptable) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75 -84% High Distinction (Exceptional) 85-100% Understanding of the Data requirements 30% Demonstrates limited understanding of the data requirements Fair understanding of the data requirements.

May neglect to provide resources or that these are cursorily provided without reference to specific areas in the source. Good understanding of the data requirements demonstrated. May provide a limited number of sources the peer can use to develop their technique from. Very good understanding of the data requirements demonstrated. Makes recommendations to other external sources the peer can access to develop their understanding.

Outstanding understanding of the data requirements demonstrated through recommendation of other sources with specific references to components of it that the peer will benefit from. Capture of key entities and their relationships 40% Less than 50% entities and relationships are completed 50-64% entities and relationships completed 65-74% entities and relationships completed 75-84% entities and relationships completed 85-100% entities and relationships completed Effective communication 30% Difficult to understand for audience, no logical/clear structure, poor flow of ideas, argument lacks supporting evidence. Audience cannot follow the line of reasoning. Information, arguments and evidence are presented in a way that is not always clear and logical.

Line of reasoning is often difficult to follow. Information, arguments and evidence are well presented, mostly clear flow of ideas and arguments. Line of reasoning is easy to follow. Information, arguments and evidence are very well presented; the presentation is logical, clear and well supported by evidence. Demonstrates cultural sensitivity.

Expertly presented; the presentation is logical, persuasive, and well supported by evidence, demonstrating a clear flow of ideas and arguments. Engages and sustains audience’s interest in the topic, demonstrates high levels of cultural sensitivity. MIS602 Assign 3 Page 4 of 4 MIS602 – Data Modelling & Database Design Assessment 3 – Reflective research report i TABLE OF CONTENT: Table of content: ............................................................................................................. i 1) Introduction .......................................................................................................... ) Background .......................................................................................................... ) Why implementing an information system? ........................................................ ) Actual scenario .....................................................................................................

4 Database system ......................................................................................................... 4 Risks ........................................................................................................................... 4 Knowledge management ............................................................................................ ) Benefits of implementing a database system ....................................................... ) Relational database .............................................................................................. ) Royal Rundle Hospital database system .............................................................. ) Main Business Operations and Data Needs ......................................................... ) Stakeholder map ................................................................................................. ) Entity relationship diagram (ERD) .................................................................... ) Implementation .................................................................................................. ) Conclusion ......................................................................................................... ) Reflective analysis ............................................................................................. ) References .......................................................................................................... ) Table of figures .................................................................................................. 19

Paper for above instructions

Reflective Research Report on the Implementation of a Database System for Royal Rundle Hospital (RRH)

1) Introduction

The healthcare industry is undergoing a significant transformation due to rapid advancements in technology. The Royal Rundle Hospital (RRH), which has operated for over 50 years, seeks to modernize its patient record management systems from paper-based documents and spreadsheets to a robust database system. This report will explore the data requirements, benefits, challenges, and the overarching feasibility of implementing an automated database system in RRH.

2) Background

RRH provides a wide range of services including surgical, maternity, emergency, mental health, and allied health services. Currently, its operations rely heavily on manual documentation processes, leading to inefficiencies and risks associated with data management. To enhance operational efficiency and improve patient care, the management has recognized the urgent need for an information technology-driven solution.

3) Why Implementing an Information System?

The implementation of an information system will streamline hospital management by centralizing data storage, reducing redundancy, and ensuring quick access to patient information. Digitization will also facilitate better data integrity and error reduction—outcomes essential in healthcare settings where accurate patient information can impact treatment decisions (Heathfield, 2023; Haux, 2018).

4) Actual Scenario

In its current setup, RRH utilizes a combination of paper forms and spreadsheet software for managing key patient information and departmental data. Such practices not only induce data inaccuracies but are also time-consuming, thereby compromising the quality of patient care.

5) Database System

The proposal includes the development of a relational database that encompasses several key modules focusing on various operations at RRH (Elmasri & Navathe, 2015). The following entities have been identified:
- Patients
- Doctors
- Departments
- Admissions
- Discharges
- Charges

6) Risks

Transitioning to a database system does not come without risks. Potential data breaches, system downtimes, and the steep learning curve for hospital staff are notable concerns (Braun et al., 2020). Therefore, a risk mitigation strategy must be part of the implementation plan.

7) Knowledge Management

Knowledge management plays a crucial role in hospital operations by ensuring that patient information is documented correctly and includes learning from past patient care experiences (Davenport, 2020). An integrated database can support knowledge management by allowing easy retrieval and analysis of patient histories.

8) Benefits of Implementing a Database System

Implementing a database system will manifest numerous benefits, including:
- Improved access to patient records: Staff can quickly access patient information leading to better-informed treatment plans (Mostafa et al., 2022).
- Enhanced data integrity and security: Robust data security measures can be instilled to safeguard patient information.
- Increased operational efficiency: Automation of routine tasks (admissions, discharges) will free up staff for patient-centric activities (Haux, 2018).

9) Relational Database Design

The database design will follow the principles of normalization to ensure an efficient structure that eliminates redundancy while maintaining data integrity. The schema will be designed to satisfy 3NF, streamlining the types of relationships among entities.

10) Royal Rundle Hospital Database System

Based on the operational workflow of RRH, the database will focus on critical modules: Patient Management, Doctor Management, Billing and Charges, Departmental Management, and Reporting (Elmasri & Navathe, 2015).
The detailed Entity-Relationship Diagram (ERD) presents the various entities identified and their relationships:
- Patients (1,1) --- < admissions > --- (0,N) Admissions
- Patients (1,1) --- < discharged from > --- (0,N) Discharges
- Doctors (1,1) --- < manages > --- (1,N) Departments
- Departments (1,1) --- < conducts > --- (0,N) Operations
- Patients (1,N) --- < incurs > --- (0,N) Charges

11) Stakeholder Map

The stakeholder map is crucial for identifying the key players involved in the implementation process. Important stakeholders include:
- Hospital management
- Medical staff (doctors, nurses)
- IT personnel
- Patients
Engaging these stakeholders early will help to foster support and ensure successful adoption.

12) Implementation

Implementation requires a multi-phase approach beginning with data migration, training staff, and testing the system for real-world scenarios. A proper change management plan will be developed to ease the transition and mitigate resistance from staff (Kotter, 1996).

13) Conclusion

An automated database system for the Royal Rundle Hospital presents a viable solution to current data management challenges. By streamlining patient interactions, safeguarding information, and enhancing usability, the potential merits of the system far outweigh the inherent risks involved.

14) Reflective Analysis

Throughout the study, I have gained valuable insights into data modelling and database design principles. The learning outcomes include understanding the importance of stakeholder involvement, designing ERDs, and the role of relational databases in improving organizational efficiency. Furthermore, the challenges posed by system transition—both technical and human factors—underscore the necessity for careful planning and execution.

References

1. Braun, J., Tomazic, T., & Wöhrmann, A. (2020). Managing IT Risks in Healthcare: A Comprehensive Framework. International Journal of Medical Informatics.
2. Davenport, T. H. (2020). The AI Advantage: How to Put the Artificial Intelligence Revolution to Work. MIT Press.
3. Elmasri, R., & Navathe, S. (2015). Fundamentals of Database Systems. Pearson.
4. Haux, R. (2018). Health information systems—past, present and future. International Journal of Medical Informatics.
5. Heathfield, S. M. (2023). Data Management in Healthcare. Journal of Healthcare Management.
6. Kotter, J. P. (1996). Leading Change. Harvard Business School Press.
7. Mostafa, M. M., Saad, H. F., & El-Din, M. H. (2022). The Impact of Automated Systems on Patient Care Quality. Journal of Hospital Management.
8. Ponnusamy, K., & Bhuvaneshwari, T. (2021). Implementing Effective Information Systems in Hospitals for Improved Data Management. Healthcare Technology Letters.
9. Silvestri, A., & Jones, M. (2019). Risk management in healthcare IT implementation. International Journal of Technology Assessment in Health Care.
10. Wang, J. C., & Xu, J. (2018). A framework for effective knowledge management in healthcare institutions. Journal of Knowledge Management.
This report presents a comprehensive approach to evaluating the data management needs of RRH, setting the foundation for a successful implementation of a database system that meets both current and future healthcare challenges.