agrred
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 doctors 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 stylethat is, providing a solution to
the problem as outlined by the clientwith a deep reflection on what you have learned in the
MIS602 Assign 3 Page 2 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 hospitals 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
audiences interest in the
topic, demonstrates high
levels of cultural sensitivity.
