back to top
Due Date: 09-Apr-2020
Return Date: 06-May-2020
Submission method options: Alternative submission method
back to top
Part A: Database research (5 Marks)
Your task is to explore the topic of In-Memory Databases and write down a small report discussing what they are, why they were needed, and what are some recent developments happening in this area.
Your research report must be well presented using proper content organization. Cite all information sources using APA style. The expected word count is approximately 500 words.
Part B: Data Modelling (10 Marks)
Read the following case study and then carry out the data modelling tasks as described later.
ProactiveSense is a startup business that provides a sensor based monitoring solution to the healthcare providers. The basic idea is that many patients nowadays require a constant monitoring of their body parameters. Instead of regular visits to the healthcare facilities, patients can wear different kind of biosensors which constantly record their information. Sensing devices can record a variety of patient data such as body temperature, heart rate, blood pressure, skin perspiration, respiration rate, blood glucose and blood oxygen level. Sensors come in several form factors such as smartwatches, wrist bands, headbands, clips-on badges, ingestible pills and smart implants. All sensors send the recorded data to a smartphone app via Bluetooth. The app uploads the data regularly to ProactiveSense servers. The health care personnel can view the data and reports by logging on to those servers.
The company’s database system needs to record information about sensors, patients and their caregivers (health care staff). Patient’s details include their name, DoB and contact details. Each patient is allocated one or more sensor devices. Each patient is also assigned one or more caregivers who will have access to patient health data. Caregivers may include doctors, nurses, medical data scientists etc. Patients can also define an easy to recognize name for each of their sensor devices. All sensor readings should be tagged with correct date and time. For every kind of reading there are two thresholds — a maximum and minimum. If the readings happen to exceed or fall below those thresholds, the system must send an alert to all of the patient’s caregivers. The alerts should be labelled with their priority level such as normal, urgent, critical etc. Upon receiving an alert, one of the caregivers reviews the received information and takes an appropriate action such as calling the patient to discuss their health or asking them to visit their healthcare facility. Whatever action is taken, it must be recorded in the system along with identity of the caregiver. Aside from the alerts, the caregivers may also like to generate routine reports about their patients. Each report would have a starting and ending date to indicate the period for which the data is sought. The report would contain all readings in that period from a specific sensor device.
Create a complete Entity Relationship Diagram (ERD) that can be implemented in the relational model. For a complete diagram, you will need to carefully deduce all the business rules from the given scenario. Use Crow’s Foot notations and make sure to include all of the following:
· All entities (2 marks)
· Attributes for each entity (2 marks)
· Primary key and any foreign key attributes for each entity (2 marks)
· The relationships between entities (2 marks)
· The type of connectivity and optionality of each relationship (2 marks)
For guidance on how to draw an ERD based on business rules, watch this video: https://www.youtube.com/watch?v=YvJ4t9_2SWk
To draw the diagrams, you should use a drawing tool like Draw.io, Lucidchart, LibreOffice Draw etc. Hand-drawn diagrams are NOT acceptable.
Include your student ID and full name under the ERD then copy the whole ERD as an image to your Word document.
back to top
SUBJECT LEARNING OUTCOMES
This assessment task will assess the following learning outcome/s:
· be able to model complex business rules using Entity Relationship Diagrams (ERDs).
· be able to research a recent development in the field of database technology.
GRADUATE LEARNING OUTCOMES
This task also contributes to the assessment of the following CSU Graduate Learning Outcome/s:
· Information and Research Literacies (Knowledge) – CSU Graduates demonstrate that disciplinary knowledge is developed through research and evidence.
MARKING CRITERIA AND STANDARDS
back to top
be able to research a development in the field of database technology.
Demonstrates an excellent ability at researching recent developments in the field of database technology with all the responses supported by examples and use correct terminology.
Demonstrates a good ability at researching recent developments in the field of database technology with most responses supported by examples and use correct terminology.
Makes a genuine attempt at researching recent developments in the field of database technology with some responses supported by examples and use correct terminology.
Limited knowledge of the implementation considerations and a basic explanation of the security issues.
be able to model complex business rules using Entity Relationship Diagrams (ERDs).
Model identifies all PKs, attributes and relationships. Model accurately represents all four business rules and includes all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities.
Model identifies PKs, attributes and relationships with minor omissions. Model accurately represents the business rules and includes the identified entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities.
Model identifies key PKs, attributes and relationships. Model represents key business rules and includes the related entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities.
Model represents key business rules and draws out the key relationships. It includes the related entities, PKs, attributes, relationships, cardinalities and optionalities with minor errors.
back to top
back to top
Correct referencing is critical for the Research part of the assignment. You must cite all sources of information using APA 6th ed. referencing style. Guidance on correct referencing can be obtained at CSU Referencing site or the Academic Referencing Tool (ART)