Data Modeling , ERD Diagram

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: [login to view URL] To draw the diagrams, you should use a drawing tool like [login to view URL], Lucidchart, LibreOffice Draw etc. Hand-drawn diagrams are NOT acceptable.