All posts by : chebby

PFA..

1 – Discussion

2 – Assignment

3 – Practical connection

NOTE: **** post answers in separate documents for each Question

      **** Please follow the instructions to the point and pick relavant topics according to the subject

      **** Follow APA7 format

a. Write two stored procedures (must have at least 6-10 parameters of different datatype) to insert and update the data. 

b. Stored procedure should insert the records in multiple tables (meaning inserting or updating data in parent and child tables). In this scenario you insert data first in parent table get the key column ID value and use it as reference key value to insert in the second table)

c. Write a cursor to loop the set of records and perform the data update

d. Write a select statement using Common Table Expressions (CTE)

Please give me not only the answer but also the steps.

 Go  to the website: https://epic.org/privacy/litigation/ which focuses on civil rights issues and privacy. Pick a case.

Prg 420 

Modify the Week Two Java™ application using Java™ NetBeans™ IDE to meet these additional and changed business requirements:

The company has recently changed its total annual compensation policy to improve sales.

· A salesperson will continue to earn a fixed salary of $75,000. The current sales target for every salesperson is $120,000.

The sales incentive will only start when 80% of the sales target is met. The current commission is 5% of total sales.

If a salesperson exceeds the sales target, the commission will increase based on an acceleration factor. The acceleration factor is 1.5%.

The application should ask the user to enter annual sales, and it should display the total annual compensation.

The application should also display a table of potential total annual compensation that the salesperson could have earned, in $5000 increments above the salesperson’s annual sales, until it reaches 50% above the salesperson’s annual sales.

Sample Table: Assuming a total annual sales of $100,000, the table would look like this:

Total Sales

Total Compensation

100,000

<>

105,000

<>

110,000

<>

115,000

<>

120,000

<>

125,000

<>

130,000

<>

135,000

<>

140,000

<>

145,000

<>

150,000

<>

The Java™ application should also meet these technical requirements:

· The application should have at least one class, in addition to the application’s controlling class.

· The source code must demonstrate the use of conditional and looping structures.
There should be proper documentation in the source code.

CARDIAC CARE UNIT

ST GEORGE’S HOSPITAL

Your program will read one input sequential file. You will use textfile “patients.txt” which is located on tracs as a test file but you must write your program so that it invokes the dialog feature of C# ***** the user can select the input file form a Windows template. You will submit your exam on tracs in a zipped folder. If your zipped folder contains fewer than 5KB of data it is garbage and it will receive a 0. You are allowed multiple submissions to safeguard your work, but anything submitted past the end of class will not be graded. I will grade the last submitted version.

As specified above, you should code your program so it can input data from any file the Nurse or the Doctor wants to. The format of the input file is such that the input file contains multiple sets of data for cardiac care patients and it could also be an infinite continuous stream of data records. Each set of 12 consecutive records contains data about one patient. The first record contains the patient name, the next 10 records contain 5 pairs of data representing 5 measurements of the patient’s blood pressure (Systolic over Diastolic) and the 12th record contains the id of the doctor for that patient. The first number is ***** pressure, the second number is ***** pressure, and the third number is ***** pressure and so on. The input file will look like this followed by data for the next patient and the next patient and so on.

Joe A. Patient

180

60

175

76

188

100

190

80

190

80

1There will be an unspecified number of data sets in the various input files to be processed. Your program must create 3 String constants in memory. They should hold the following string values:

D.ABRAMS,MD Dr. Abrams is doctor 0.

D.JARVIC,MD Dr. Jarvic is doctor***** Panos is doctor 2.

PROCESSING:

For each patient in the input file, your program will load the systolic and diastolic blood pressure measurements into the proper variables that you must define. You will compute the average value for each group of variables: one average value for the Systolic values and one average value for the Diastolic values and display them in a listbox, along with the “Status” and the “Doctor’s Name.”

If the average Systolic pressure of a patient is <=90 or >= 160 OR if the average Diastolic pressure is <= 60 or >= 90 then your program must display a “WARNING” under the status for that patient, otherwise you will display ‘NORMAL’ under the status for that patient. The last column of the display will show the Cardiologist’s Name for the patient.SAMPLE GUI FOR YOUR CARDIAC CARE APPLICATIONCODING SPECIFICATIONS:

DisplayPatientStatus_Button:

The codebehind the “DISPLAY PATIENT STATUS” button must only contain calls to VOID methods and Value Returning methods (known as Functions).

Write a void method ProcessFile to process the file until the end of stream and call that method from inside the button click event.

Inside this ProcessFile method your program should call the following sub-methods:

Write two separate Functions (value returning methods.) One, SystolicPressure, to accumulate and return the mean Systolic blood pressure and another Function, DiastolicPressure, to accumulate and return the mean Diastolic pressure of the current patient.

Write a Function PatientStatus, to return the patient’s STATUS after the patient’s numeric data has been processed.

Write a Function DoctorsName to return the doctor’s name.

Write a private void DisplayOutput method, to create a string and display each output line for each patient the app is processing.Clear_MonitorButton

The codebehind the “CLEAR MONITOR” button must contain calls to void methods that will do the field and variable cleaning and re-initializations.

Need questions 3 only

#1 What is Agile?

How is risk handled within an Agile project approach such as Scrum?

In what ways can the following activities be seen as projects?

In what ways do they resemble ongoing, routine business activities?

Feel free to add assumptions and details to describe how the activity might be a project in one context and routine in another.

1. Reading a chapter before attending a university lecture.
2. Taking a bus to work each day.
3. Piloting an aircraft between Vancouver and Fiji.
4. Teaching a course for the first time; teaching the same course every semester.

Text

Title: Managing Project Risks 

ISBN: 9781119489733 

Authors: Peter J. Edwards, Paulo Vaz Serra, Michael Edwards 

Publisher: John Wiley & Sons 

Publication Date: 2019-08-13

Regression and K-Means Clustering