Assessment item 2 – Research and Data Modelling
back to top
Value: 15%
Due Date: 09-Apr-2020
Return Date: 06-May-2020
Submission method options: Alternative submission method
TASK
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:
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.
RATIONALE
back to top
SUBJECT LEARNING OUTCOMES
This assessment task will assess the following learning outcome/s:
GRADUATE LEARNING OUTCOMES
This task also contributes to the assessment of the following CSU Graduate Learning Outcome/s:
MARKING CRITERIA AND STANDARDS
back to top
PART A:
| Criteria | HD | DI | CR | PS |
| 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. |
PART B:
| Criteria | HD | DI | CR | PS |
| 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. |
PRESENTATION
back to top
REQUIREMENTS
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).
Assessment item 2 – Research and Data Modelling
back to top
Value: 15%
Due Date: 09-Apr-2020
Return Date: 06-May-2020
Submission method options: Alternative submission method
TASK
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:
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.
RATIONALE
back to top
SUBJECT LEARNING OUTCOMES
This assessment task will assess the following learning outcome/s:
GRADUATE LEARNING OUTCOMES
This task also contributes to the assessment of the following CSU Graduate Learning Outcome/s:
MARKING CRITERIA AND STANDARDS
back to top
PART A:
| Criteria | HD | DI | CR | PS |
| 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. |
PART B:
| Criteria | HD | DI | CR | PS |
| 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. |
PRESENTATION
back to top
REQUIREMENTS
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).
TO: Political Science Students
FROM: Dr. Smith
RE: IOM on Historical Documents/ Federalism
Date:
ISSUE
Research and discuss the historical documents of the United States of America; federalist
papers, Declaration of Independence, Bill of Limits, and Constitution. Include the
following in your discussion.
1. Date(s) of Document:
2. Author(s) of Document:
3. What was the purpose, goal or intent?
Discuss federalism use examples found in the current news to support your discussion.
Remember to use at least one source from the left and one source from the right.
TO: Political Science Students
FROM: Dr. Smith
RE: IOM on Historical Documents/ Federalism
Date:
ISSUE
Research and discuss the historical documents of the United States of America; federalist
papers, Declaration of Independence, Bill of Limits, and Constitution. Include the
following in your discussion.
1. Date(s) of Document:
2. Author(s) of Document:
3. What was the purpose, goal or intent?
Discuss federalism use examples found in the current news to support your discussion.
Remember to use at least one source from the left and one source from the right.
TO: Political Science Students
FROM: Dr. Smith
RE: IOM on Historical Documents/ Federalism
Date:
ISSUE
Research and discuss the historical documents of the United States of America; federalist
papers, Declaration of Independence, Bill of Limits, and Constitution. Include the
following in your discussion.
1. Date(s) of Document:
2. Author(s) of Document:
3. What was the purpose, goal or intent?
Discuss federalism use examples found in the current news to support your discussion.
Remember to use at least one source from the left and one source from the right.
Guidelines for Research paper
The Research Paper will be on an International Management and Business topic that is very important to the culture, climate and operational needs within the International activity. An email will be sent to the student’s individual email with the topic’s name DURING THE SECOND WEEK OF THE COURSE. D2L WILL PROVIDE ME NOTIFICATION IF YOU RECEIVED IT.
Below is your assigned topic:
“Global Cultural Differences “
RESEARCH PAPER ON AN INTERNATIONAL MANAGEMENT
AND BUSINESS TOPIC. (40% OF TOTAL COURSE GRADE)
DUE DATE May 3rd, 2020.
Below are some extractions from the objectives of the course as stated in the syllabus:
The impact of the Covid-19 Virus has already and will have major impact on the ways that organizations, entities and countries interact with one another in the future. Today we are seeing and experiencing major process changes to local supply chain management and many of these processes will remain after we return with the control of the Virus and its expansion. Think about the process changes to grocery stores, fast food operations, many services activities, as well as banking, car buying in addition to the immediate changes to education.
For the most part you are only seeing the immediate impact on education with the delivery of education as well as the support functions. Daily and continuing it is impacting the total infrastructure and processes which exist within the functions and activities of the education environment.
So, as you begin finalizing your research for your topic and start drafting please keep in mind the recent impact and future implications that you should be incorporating into your Research paper topic.
For instance:
Each of these areas should be addressed within your Research paper Topic as the above will have an impact on your functional area or geographic area which is your Research paper topic.
