New

Learn smart - Learn online. Upto 80% off on courses for a limited time. View Courses

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

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

25 Pages
NIT3202 Data Analytics For Cyber Security

Questions: Objectives• To apply skills and knowledge acquired throughout the semester in classification algorithms and machine learning process.• To rationalize the use of machine learnin ...

Course

NIT3202

Type

Assignment

Subject

Database

University

Victoria University

Season

Spring

5 Pages
DBAS27198 Database Design and Implementation

Instruction: Include screenshot of both your sql statement and output.One screenshot for each question The screenshot should be FULL screen.Refer to HR database to answer below questions:1.fi ...

Type

Programming

Subject

Database

University

Sheridan college

5 Pages
Management

Create one questionnaire that you would send to one stakeholder group with an aim to help you identify further details about the environment, the problem area and/or how the system would operate to he ...

Type

Essays

Subject

Database

41 Pages
ICT707 Data Science Practice

Questions: Assessment and Submission Details Marks: 40% of the Total Assessment for the Course   Submit your assignment to Blackboard Task 3. Please follow the submission instructions in Bl ...

Course

ICT707

Type

Programming

Subject

Database

University

University of the Sunshine Coast

MIS602 Data Modelling and Database Design

Question

Answered

Task

Context:

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.

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.

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

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
  • The RRH management has not provided any assumptions and you should list these if your proposal and reflection are to be considered

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.

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

Over the last few years, MyAssignmenthelp.com has emerged as one of the leading websites that provide high quality accounting assignment help. We provide assistance with wide ranges of assignments. We have segmented our writers in separate teams to offer maths assignment; economic assignment help and statistics assignment help as well. We have teams of expert writers to render assistance on more than 100 subjects. We offer custom-made law assignment help to students who are looking for assignment help with legal terms and structure.

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

Q
icon

We aren't endorsed by this University

NIT3202 Data Analytics For Cyber Security

Questions: Objectives• To apply skills and knowledge acquired throughout the semester in classification algorithms and machine learning process.• To rationalize the use of machine learning algorithms to effectively and efficiently process of data in big size.• To demonstrate abilit ...

View Answer
Q
icon

We aren't endorsed by this University

DBAS27198 Database Design and Implementation

Instruction: Include screenshot of both your sql statement and output.One screenshot for each question The screenshot should be FULL screen.Refer to HR database to answer below questions:1.finds the average salary of employees for each job , whose job id begins with ‘FI’ 2.Write ...

View Answer
Q

Management

Create one questionnaire that you would send to one stakeholder group with an aim to help you identify further details about the environment, the problem area and/or how the system would operate to help solve the problem.•    Identify which stakeholder you are going to send the q ...

View Answer
Q
icon

We aren't endorsed by this University

ICT707 Data Science Practice

Questions: Assessment and Submission Details Marks: 40% of the Total Assessment for the Course   Submit your assignment to Blackboard Task 3. Please follow the submission instructions in Blackboard. The assignment will be marked out of a total of 100 marks and forms 40% of the total asse ...

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

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?