ITC556 Research and Data Modelling Database system Assessment and Tutor Proposal
Charles Sturt University
ITC556 Research and Data Modelling Database system
Assessment No: 2
Student’s Score cards
Research and Data Modelling
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 (https://www.draw.io/), Lucidchart (https://www.lucidchart.com/pages/usecase/education), LibreOffice Draw
(https://www.libreoffice.org/discover/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.
Why invest in our services?
Our assignment help team is trained to provide you high quality writing services.
High scores achieved by our students is a portrayal of our high quality online assignment help
You can place your assignment order through 4 easy modes of communication