MIS602: Data Modelling & Database Design - IT Assignment Help

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

This MIS602 IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.