09 June, 2021
Transitioning to NOSQL databases from Relational Database Management System
NoSQL database is the presentation of data in a different form from the tables with relations. The NoSQL as the name suggests the database doesn’t apply the usage of SQL queries. The relational database management system on the other hand applies SQL queries on tables with relationships between the different entities (Poojary, Poriya, & Nayak, 2015). The application of NoSQL has been as a result of increase level of data due to the internet. The internet has allowed organization to access huge levels of data which are crucial towards ensuring that better decision making process is achieved. The Relational Database Management System has been application by organization for an extensive period of time and it doesn’t suit the huge influx of data due to utilization of internet. The Relational Database Management System negatively affects the ability of an organization to identify patterns thus limiting the opportunities available.
Research problems
The Relational Database Management System has problem when handling huge volumes of data. The huge volumes of data are a big constraint to organizations. The huge volumes of data are as a result of data from different sources that are crucial to business operations. The different data types of information collected by organization are impossible to be stored in the relational database system. The other problem is the huge velocity of data thus making the relational database system unsuitable to handle the data (Poojary, Poriya, & Nayak, 2015).
Research questions
Does NoSQL solve the problem facing the Relational Database Management System?
What are the benefits of using NoSQL database for business operations?
Benefits of switching to NoSQL database
According to Mukherjee NoSQL database is beneficial as compared to RDBMS since it allows the storage of unstructured, semi-structured and structured data (Mukherjee, 2020). The NoSQL allows the data to be stored in a format closer to the actual data thus making it easier for interpretation by the organization. The ability of the NoSQL database to store data in different formats is important in ensuring that business organizations are able to gain a better understanding of a business situation because of the available data. The different type’s format of data allows better patterns on the data to be identified thus allowing improved decision making process. The NoSQL offers a better ability to the individual to perform updates and change of the fields and schema. As opposed to Relational Database Management System the NoSQL database is more flexible and allows the developer to keep changing the schema and field to suit the source of the data. The flexibility is important in ensuring that the data collected from the consumers is more advanced and suitable to the needs of the organization (Teodoro, Wei-Kleiner, Sundvall, Karlsson, & Lambrix, 2016). The consumer trends from the data keeps on changing thus it is important for the schema to change to suit the raw data. NoSQL fully utilizes the cloud resources thus reducing the downtime that might be experienced by the organizations. The Relational Database Management System is doesn’t fully utilize the cloud resources thus they are impacted by downtimes (Ali, Shafique, Raza, & Majeed, 2019). Downtimes in organization negatively affect the business processes of organizations. It results in delays of business operations thus negatively impacts the customer satisfaction level.
References
Ali, W., Shafique, M. U.,Raza, A., & Majeed, M. A. (2019). Comparison between SQL and NoSQL Databases and Their Relationship with Big Data Analytics. Asian Journal of Computer Science and Information Technology 4(2) , 1 - 10.
Mukherjee, S. (2020). The Battle between NoSQL Databases and RDBMS. SSRN Journal, Retrieved from https://papers.ssrn.com/sol3/papers.cfm?abstract_id=3393986 , 1 - 7.
Poojary, D., Poriya, A., & Nayak, A. (2015). Type of nosql databases and its comparison with relational databases. International Journal of Applied Information Systems , 16 - 19.
Teodoro, D., Wei-Kleiner, F., Sundvall, E., Karlsson, D., & Lambrix, P. (2016). Comparing the Performance of NoSQL Approaches for Managing Archetype-Based Electronic Health Record Data. Plos One , 1 - 16.
15 October, 2020
Write a loop that subtracts 1 from each element in lowerScores.
1. Write a loop that subtracts 1 from each element inlowerScores. If the element was already 0 or negative, assign 0 tothe element. Ex: lowerScores = {5, 0, 2, -3} becomes {4, 0, 1,0}.
what i am given
import java.util.Scanner;
public class StudentScores {
public static void main (String [] args) {
Scanner scnr = new Scanner(System.in);
final int SCORES_SIZE = 4;
int[] lowerScores = new int[SCORES_SIZE];
int i;
for (i = 0; i < lowerScores.length; ++i) {
lowerScores[i] = scnr.nextInt();
}
/* Your solution goes here */
for (i = 0; i < lowerScores.length; ++i) {
System.out.print(lowerScores[i] + " ");
}
System.out.println();
}
}
2.
Write a loop that sets newScores to oldScores shifted once left,with element 0 copied to the end. Ex: If oldScores = {10, 20, 30,40}, then newScores = {20, 30, 40, 10}.
Note: These activities may test code with different test values.This activity will perform two tests, both with a 4-element array(int oldScores[4]). See "How to Use zyBooks".
Also note: If the submitted code tries to access an invalid arrayelement, such as newScores[9] for a 4-element array, the test maygenerate strange results. Or the test may crash and report "Programend never reached", in which case the system doesn't print the testcase that caused the reported message.
what i am give.
import java.util.Scanner;
public class StudentScores {
public static void main (String [] args) {
Scanner scnr = new Scanner(System.in);
final int SCORES_SIZE = 4;
int[] oldScores = new int[SCORES_SIZE];
int[] newScores = new int[SCORES_SIZE];
int i;
for (i = 0; i < oldScores.length; ++i) {
oldScores[i] = scnr.nextInt();
}
/* Your solution goes here */
for (i = 0; i < newScores.length; ++i) {
System.out.print(newScores[i] + " ");
}
System.out.println();
}
}
3. Write a loop that sets each array element to the sum ofitself and the next element, except for the last element whichstays the same. Be careful not to index beyond the last element.Ex:
Initial scores: 10, 20, 30, 40Scores after the loop: 30, 50, 70, 40The first element is 30 or 10 + 20, the second element is 50 or20 + 30, and the third element is 70 or 30 + 40. The last elementremains the same.
what i am given
import java.util.Scanner;
public class StudentScores {
public static void main (String [] args) {
Scanner scnr = new Scanner(System.in);
final int SCORES_SIZE = 4;
int[] bonusScores = new int[SCORES_SIZE];
int i;
for (i = 0; i < bonusScores.length; ++i) {
bonusScores[i] = scnr.nextInt();
}
/* Your solution goes here */
for (i = 0; i < bonusScores.length; ++i) {
System.out.print(bonusScores[i] + " ");
}
System.out.println();
}
}
27 May, 2020
This task is to be done in groups which must have been approved by your tutor. Assignments will be returned to you within two to three weeks of submission. Feedback on this assignment will be provided via a rubric which will be available on the course website. Please read the assessment summary and assessment details sections of your course outline booklet carefully for further information relating to assessment in this course.
SPECIFICATIONS
This assignment will enable you to improve your skills as a systems analyst and carry out various activities in the systems analysis phase of the systems development life cycle. It requires you to investigate and document system requirements, identify and document use cases, carry out domain modelling and use case modelling.
The assignment should be created using the template provided on the course website.
Each group member is also required to fill out the “Declaration of Contribution” form which is available in the assignment template document. As stated in the form, if any contribution does not meet the assessment requirements, the course coordinator may adjust individual marks up or down, depending on the level of contribution made.
Marking Criteria
The rubric that will be used when assessing your work will be available on the course website. The word limit will not be checked for this assessment. This task will assess completeness of the objectives listed below.
• Completeness, suitability and thoroughness of responses to the questions
• Technical correctness of the various models created;
• Adequate presentation and format;
• Use of the template provided;
• Correct spelling and grammar;
• Clarity of expression;
• Clearly labelled questions and answers;
2 Submission Instructions
The assignment MUST be submitted via Learnonline through the course website or via MyUniSA. Please submit ONLY ONE assignment per group – nominate someone to submit the assignment on the group’s behalf. Include as part of your submission ONE .pdf document containing the responses to the questions relating to the given scenario. Individual submissions will NOT be considered or marked. Refer to your course outline for further information regarding extensions. Late submissions will not be accepted for this course unless an extension has been approved by the course coordinator (see section on extensions in your course outline for further details). Late submissions that have not been approved will receive a mark of zero.
***IMPORTANT INFORMATION***
It is up to each group to make sure that the submitted work does not contain any parts copied from another group in this or any previous year, from this or any similar course; or from a common source such as a textbook or website. The assignment must be your own collective work, and not contracted to a substitute person. If we are suspicious, we reserve the right to call you in and to test your understanding of what you have submitted in an oral examination. If plagiarism is detected it will be investigated and appropriate consequences will follow.
SCENARIO
A Medical Practice has tasked your team to develop the requirements for their medical practice management system. The system is to allow the practice to record patient appointments and allow doctors to capture the medical history of their patients. A patient’s primary doctor can access the details of their patients at any time. However if a patient temporarily sees a different doctor, that doctor can only access the patient’s medical records during the consultation. The system must record the times when doctors are available during business hours from Monday to Friday, 8 am to 9 pm, and Saturday and Sunday from 9 am to 4 pm. The system must be available with 98% certainty during these business hours. Response times for accessing a patient’s record, which can be a maximum of 100 megabytes, must not exceed 7 seconds. At times doctors will also be able to be rostered as a locum service in shifts from 6am to 2pm, 2 pm to 10pm or 10pm to 6am. A doctor may not be rostered on for more than 40 hours per week and if rostered as a locum shift may not take another shift without a 14 hour break. The medical practice has ten doctors. Only one doctor will be rostered on a locum shift at a time. During business hours two nurses must also be rostered on and again may not work more than 40 hours per week. A doctor consults with patients in their office and must be able to access the system from their office. The history of all updates is logged and the system is backed up daily. The system logs a person out after ten minutes without use. Doctors on the locum roster are to be provided with a tablet device with mobile phone and global positioning system connections. The application on the device is to contain an emergency call button that contacts police in the event of an emergency and transmits the address that the doctor is consulting at. The tablet device application is to be able to connect with the patient records stored at the main medical practice but only show the record of the patient that the doctor is consulting with at that time. Doctors consult with patients in either fifteen minute or 30 minute blocks. In addition to a patient’s medical history, a patient’s record must include their name, address, date of birth, emergency contacts, any current medications, a photograph of their face and key details such as hair colour, eye colour, height, weight and gender. Associated with a patient but stored separately is their financial records – bills incurred, outstanding and medical insurance details. The reception staff must be able to manage appointments in person or on the phone for new and existing patients. After an appointment, the reception staff must be able to call up the billing information for a patient based on what services a doctor has provided, accept cash or electronic payment and print out invoices for the patient or their parent, guardian or carer. Note that a patient without private medical insurance receives a Medicare rebate on their services and a patient with private medical insurance receives an additional rebate but there typically is some gap fee that remains to be paid. The business manager for the Practice must also be able to access the system for basic accounting activities, transferring the data into a standard accounting package for analysis. The business manager must be able to identify the total Medicare rebate as well as the Private Insurance company rebates and invoice accordingly. The business manager must also be able to identify the costs of the business associated with the time sheets that doctors complete each week. Doctors enter their time sheets via their office computer. Finally doctors must be able to access the Internet from their terminals and as well use the specialist Pharmacy application provided by AAA Pharmacy Pty Ltd. Each doctor must be able to print scripts for patients from their office or the surgery, the receptionists print invoices for patients and the business manager prints report information. It is imperative that patient privacy is strictly respected so there must be suitable security measures in place to ensure this. The Practice has one IT administrator that can perform general IT duties for the terminals and servers but must not be able to access patient records without an additional password entered by the most senior doctor of the practice. The system is expected to handle approximately 300 patients.
QUESTIONS 1.
SYSTEM REQUIREMENTS
a. Who are the stakeholders for the system? Provide your response using the grid format and/or template given in the previous assignment. For each stakeholder identified, list what aspects of the system are of particular interest to them. Express stakeholders’ interests using the following template: “As a
22 May, 2020
Test of Association Assignment
P value is 0.2850565 to four decimal places is 0.2851
hence it is similar to the p-value using assocstats ()
12 March, 2020
Final Research
26 January, 2020
Lab 4 - Mutability
Lecturer:
|
|
Report Title:
|
|
Submit to:
|
|
Deadline for submission:
|
|
Student Name:
|
|
Student Number:
|
|
Programme of Study:
|
|
Module:
|
|
Description
Aims
Method
Results
and Testing
Conclusions
References
Appendices
-
Lab 4 - Mutability “Immutable objects are simple. They can only be in one state, which is carefully controlled by the constructor. One ...
-
Develop a Java application that determines the gross pay for each of three (3) employees. The company pays straight time for the first 40...
-
Note: Assignment 1 requires you to create five (5) programs. Program 1 In this new age of Technology (Website, social media, etc., we have...