MIS602 Data Modelling and Database Design : Royal Rundle Hospital

$20 Bonus + 25% OFF

Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!

Students Who Viewed This Also Studied

MIS602 Data Modelling and Database Design

Task:

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.

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,
  1. 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 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.

MIS602 Data Modelling and Database Design

Answer in Detail


Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

24 More Pages to Come in This Document. Get access to the complete answer.

On-time delivery of any assignment help runs in the system of all the writers working behind MyAssignmenthelp.com. Our 3000+ highly qualified writers never compromise on the delivery of any academic assignment help material to students. However, tough an assignment topic may be, our writers always manage to complete the work correctly and prior to the deadline. Hence, many students from US, UK and Australia prefer our brand to avail online assignment help on any subject. You can also expect punctual assignment help services from our writers regarding custom essay writing, dissertation writing or homework writing. After receiving your assignment help material into your email inbox, you can contact us through 24/7 live chat support anytime. Our talented back office staff will address all your assignment related queries patiently through chat.

More MIS602 MIS602 Data Modelling and Database Design: Questions & Answers

MBA580 Innovation Strategy High Performance Organizations

I have attached the rubric in a word document of the assignment that needs to be completed. I have also attached some other documents that will help in completing this assignment. Overview Using the recommendation that you provided in Milestone One, you will develop a strategy to implement the innov …

View Answer

7516NSC Strategic Airline and Airport Management

Question:
Task : Airline Business Proposal
Task Description
This task is a team assessment requiring you to present a short pitch for an imaginary banker/investor (most likely your instructor) so you can recover a bankrupt airline after the COVID19 crisis. The presentation must be short, conci …

View Answer

MBA503 Operations Management and Decision Making Models

Task:
Operations management transforms inputs (labour, capital, equipment, land, buildings, materials and information) into outputs (goods and services) that provide added value to customers. It does not matter whether the organisation is a for-profit company, a non-profit organisation (religious o …

View Answer

OPER1160 Introduction to Supply Chain and Operations Management

1)Analysis for the Case Process: Based on your total cost analysis of Figure 1 and the findings from your research on the industry, list and explain your choices for the five performance dimensions or criteria, then utilize a weighted-point evaluation matrix to evaluate the two options. You are to s …

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.

Choose Our Best Expert to Help You

Dodge Vaughan

I have earned my doctorate credential on quantum physics from the University of Bristol.

200 – Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

38983 Genuine Reviews With a Rating of 4.9/5.

Statistics

Course Work: 5 Pages, Deadline:
6 days

The assignment was well written and had the correct information required by the professor. This was extraordinary work regarding statistics, and I am …

User ID: 8***35 Saint Louis, United States

Marketing

Assignment: 1 Page, Deadline:
13 hours

assignment help is very good and essentialpassed with ease and no stress at all

User ID: 4***40 St. Catharines, Canada

Physics

Essay: 1 Page, Deadline:
13 days

Did wonderful work, not only on time, but with great marks! Guaranteed “A” when it comes to physics or the sciences.

User ID: 6***06 Atlanta, United States

Biology

Home Work: 2 Pages, Deadline:
3 days

Very reliable and trustworthy , I always get good mark for the assignment , thank you for helping .

User ID: 4***73 Atlanta, Australia

Assignment

Essay: 1 Page, Deadline:
1 day

Good essay fast and reliable to trust ,fast communication great support from team

User ID: 8***11 Atlanta, Nigeria

Webpage Design

Programming: 12 Pages, Deadline:
1 day

I got 55%, I explained to the expert and deadline was met most importantly. Ggggg

User ID: 8***76 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
6 days

Great work, everything was clear and legible. I can always count on excellent work, thank you.

User ID: 4***77 United Kingdom, United States

Assignment

Assignment: 1 Page, Deadline:
7 days

thank you, you did a good job. the teacher suggest that you should use more detail to support your agrument

User ID: 7***90 Saint Louis, United States

Healthcare

Home Work: 2 Pages, Deadline:
1 day

Superb work, very impressed. The help just continues to be of the best quality. I couldn’t ask for better support

User ID: 6***81 Saint Louis, United States

Supply Chain

Programming: 3 Pages, Deadline:
9 days

Outstanding work. I will work with you again and again soon. I really appreciate your help; thank you so much.

User ID: 8***71 Riyadh, Saudi Arabia

Property Law

Course Work: 1 Page, Deadline:
20 days

all work is done very well, i think i will ask more help from you in future. Thanks

User ID: 8***63 Riyadh, Australia

Management

Assignment: 12 Pages, Deadline:
10 days

Credit to the expert who did a great job with this assignment! Covered most of the requirements! Thank you!

User ID: 3***95 Riyadh, Singapore

Business Law

Home Work: 4 Pages, Deadline:
9 days

Solution was provided in a timely manner. Expert managed to meet my expectation. Have yet to receive my result yet

User ID: 8***16 Riyadh, Singapore

Statistics

Programming: 4 Pages, Deadline:
4 days

This company has taken their work seriously and did a great job in producing a top quality assignment. highly recommended.

User ID: 7***37 Riyadh, Singapore

Assignment

Essay: 5 Pages, Deadline:
3 days

The writer did an awesome job with my assignment. This is my third time with them and they have kept to their quality of work.

User ID: 7***37 Riyadh, Singapore

Management

Assignment: 12 Pages, Deadline:
19 days

I am very happy to get my 100% Grade in my assessment. I wish say thank you so much.

User ID: 4***18 Riyadh, Australia

Project Management

Assignment: 4 Pages, Deadline:
9 days

Well written with sheer creativity. Always on time. Well done. I surely will recommend.

User ID: 1***16 Bella Vista, Australia

Healthcare

Essay: 2 Pages, Deadline:
15 days

Nice work! Thanks for the revision. It meets the requirement now. I am very satisfied with the work.

User ID: 7***67 Bella Vista, United States

Marketing

Home Work: 1 Page, Deadline:
23 days

Good job. Will use expert again. Thank you for your help and time that I needed on this assignment.

User ID: 5***56 San Francisco, United States

Accounting

Essay: 2 Pages, Deadline:
8 days

Received a 90/90 on my assignment, thank you to the professionals for completing this in a timely manner.

User ID: 8***75 San Francisco, United States

Statistics

Course Work: 5 Pages, Deadline:
6 days

The assignment was well written and had the correct information required by the professor. This was extraordinary work regarding statistics, and I am …

User ID: 8***35 Saint Louis, United States

Marketing

Assignment: 1 Page, Deadline:
13 hours

assignment help is very good and essentialpassed with ease and no stress at all

User ID: 4***40 St. Catharines, Canada

Physics

Essay: 1 Page, Deadline:
13 days

Did wonderful work, not only on time, but with great marks! Guaranteed “A” when it comes to physics or the sciences.

User ID: 6***06 Atlanta, United States

Biology

Home Work: 2 Pages, Deadline:
3 days

Very reliable and trustworthy , I always get good mark for the assignment , thank you for helping .

User ID: 4***73 Atlanta, Australia

Assignment

Essay: 1 Page, Deadline:
1 day

Good essay fast and reliable to trust ,fast communication great support from team

User ID: 8***11 Atlanta, Nigeria

Webpage Design

Programming: 12 Pages, Deadline:
1 day

I got 55%, I explained to the expert and deadline was met most importantly. Ggggg

User ID: 8***76 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
6 days

Great work, everything was clear and legible. I can always count on excellent work, thank you.

User ID: 4***77 United Kingdom, United States

Assignment

Assignment: 1 Page, Deadline:
7 days

thank you, you did a good job. the teacher suggest that you should use more detail to support your agrument

User ID: 7***90 Saint Louis, United States

Healthcare

Home Work: 2 Pages, Deadline:
1 day

Superb work, very impressed. The help just continues to be of the best quality. I couldn’t ask for better support

User ID: 6***81 Saint Louis, United States

Supply Chain

Programming: 3 Pages, Deadline:
9 days

Outstanding work. I will work with you again and again soon. I really appreciate your help; thank you so much.

User ID: 8***71 Riyadh, Saudi Arabia

Property Law

Course Work: 1 Page, Deadline:
20 days

all work is done very well, i think i will ask more help from you in future. Thanks

User ID: 8***63 Riyadh, Australia

Management

Assignment: 12 Pages, Deadline:
10 days

Credit to the expert who did a great job with this assignment! Covered most of the requirements! Thank you!

User ID: 3***95 Riyadh, Singapore

Business Law

Home Work: 4 Pages, Deadline:
9 days

Solution was provided in a timely manner. Expert managed to meet my expectation. Have yet to receive my result yet

User ID: 8***16 Riyadh, Singapore

Statistics

Programming: 4 Pages, Deadline:
4 days

This company has taken their work seriously and did a great job in producing a top quality assignment. highly recommended.

User ID: 7***37 Riyadh, Singapore

Assignment

Essay: 5 Pages, Deadline:
3 days

The writer did an awesome job with my assignment. This is my third time with them and they have kept to their quality of work.

User ID: 7***37 Riyadh, Singapore

Management

Assignment: 12 Pages, Deadline:
19 days

I am very happy to get my 100% Grade in my assessment. I wish say thank you so much.

User ID: 4***18 Riyadh, Australia

Project Management

Assignment: 4 Pages, Deadline:
9 days

Well written with sheer creativity. Always on time. Well done. I surely will recommend.

User ID: 1***16 Bella Vista, Australia

Healthcare

Essay: 2 Pages, Deadline:
15 days

Nice work! Thanks for the revision. It meets the requirement now. I am very satisfied with the work.

User ID: 7***67 Bella Vista, United States

Marketing

Home Work: 1 Page, Deadline:
23 days

Good job. Will use expert again. Thank you for your help and time that I needed on this assignment.

User ID: 5***56 San Francisco, United States

Accounting

Essay: 2 Pages, Deadline:
8 days

Received a 90/90 on my assignment, thank you to the professionals for completing this in a timely manner.

User ID: 8***75 San Francisco, United States

Have any Query?

The post MIS602 Data Modelling and Database Design : Royal Rundle Hospital appeared first on My Blog.

GET HELP WITH YOUR HOMEWORK PAPERS @ 25% OFF

For faster services, inquiry about  new assignments submission or  follow ups on your assignments please text us/call us on +1 (251) 265-5102

Write My Paper Button

WeCreativez WhatsApp Support
We are here to answer your questions. Ask us anything!
👋 Hi, how can I help?
Scroll to Top