It is a project, and we are using RStudio’s

1) Use the database and tables from last week’s assignment to write the following SQL queries .
a. Write a SQL query to increase all employees’ salaries with the selected EEO-1 classification by 10%. Use Update and include a join with Job_title.
b. Write a SQL query to increase all employees’ salaries by 5%. Use Update.
c. Write a SQL query that to select an employee from the Employee table and delete that employee.
Note: To delete or update a specific record you must specify the records primary key.
d. Deliverable: Save each SQL Statement you write in a Word file and post in your individual forum with your week 4 individual assignments.
 

2) Use the database and tables from last week’s assignment to write SQL statements that do the following:
a) Calculate the average salary for all employees.
b) Calculate the maximum salaries for exempt and non-exempt employees.
Use Group By and include a join with Job_title
c) Calculate the maximum salary for all employees.
d) Calculate the minimum salaries for exempt and non-exempt employees.Use Group By and include a join with Job_title
e) Calculate the minimum salary for all employees.
f) Deliverable: Save each query you write in a Word file and post in your individual forum with your week 4 individual assignments.

Create  a  portfolio related to work experience  in Information Technology . Write a paper that outlines  any projects  you have  worked on as  a  student  or professional  that  may  influence  a  hiring  manager or  company to hire  you

Introduction 

Literature review Analysis: Follow down instructions 

1. Please fill out this form (also available in this week’s folder) to compare and contrast your three research articles (do not include your news article). 

Compare and contrast articles – Form to fill out

 2. Please write part 2 of your literature review. You will be essentially cutting and pasting your three objective summaries under Level II headings (see p 13 in your manuals)

Put them in an order that makes sense given how you compared and contrasted them.

Use your transition compare and contrast words (similiar to…etc) !!! (this is also available in this week’s folder)

compare and contrast words

Submit BOTH assignments here.

Final paper

Develop a disaster recovery plan for an organization. There are many different templates available online for you to use as reference and guidance. Your plan should cover the following sections (these sections detail the elements in a DR plan in the sequence defined by industry compliance standards ISO 27031 and ISO 24762).This section should summarize key action steps (such as where to assemble employees if forced to evacuate the building) and list key contacts with contact information for ease of authorizing and launching the plan.

•     Introduction
•     Roles and Responsibilities
•     Incident Response
•     Plan Activation
•     Document History
•     Procedures

Your paper should meet the following requirements:

• Be approximately six to eight pages in length, not including the required cover page and reference page.
• Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

Analyze, design, and document a simple program that utilizes a good design process and

incorporates sequential, selection and repetitive programming statements as well as at least one

function call and the use of at least one array. The specific problem you need to solve for the final

project is: Design a program that will allow a user to Input a list of your family members along

with their age and state where they reside. Determine and print the average age of your family

and print the names of anyone who live in Texas. You may assume that the family contains at most ten members.

I want to add a few more practical methods to a binary search tree (and practice a bit of recursion in the process). down below you will find the class BinarySearchTree with the private inner class BinaryNode.Some methods are already specified. The Improved Methods

may not be changed.

i want to add following methods

int maximumRecursive()

Finds the maximum in the entire binary search tree (using a recursive helper method) and returns it. If the tree is empty, a

java.util.NoSuchElementException is thrown out

int maximumIterative() : Finds the maximum in the binary search tree iteratively. If the tree is empty, a java.util.NoSuchElementException is thrown out

int height() : Calculates the height of the entire binary search tree. A tree without elements has height 0, a tree with exactly one element has height 1

int sum() : Calculates the sum of all numbers in the binary search tree. For an empty search tree the result should be 0

String reverseOrder() :

Returns a string representation of the tree with all elements sorted in descending order. The string should – similar to the return of toString – have the following form have: 12, 8, 2, 0, -1, .

The code

public class BinarySearchTree {

private class BinaryNode {
private int element;
private BinaryNode left;
private BinaryNode right;

private BinaryNode(int element) {
this.element = element;
}
}

private BinaryNode root;

public void insert(int newNumber) {
// special case: empty tree
if (root == null) {
root = new BinaryNode(newNumber);
return;
}

BinaryNode parent = null;
BinaryNode child = root;
while (child != null) {
parent = child;
if (newNumber == child.element) {
//number already in tree
return;
} else if (newNumber < child.element) {
child = child.left;
} else {
child = child.right;
}
}

if (newNumber < parent.element) {
parent.left = new BinaryNode(newNumber);
} else {
parent.right = new BinaryNode(newNumber);
}
}

}

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

Describe in detail and provide at least one example of what IT Risk Management is. Also, discuss the necessity of risk management and disaster recovery in the context of major disasters (such as 9/11).

Your assignment should meet the following requirements:

• 2-4 pages, not including the cover page and reference page.
• Conform to APA Style.
• Support your answers with the readings from Module 01 and at least one current scholarly journal article (not more than five years old). The Rasmussen Library is a great place to find resources.
• Clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing. If you need assistance with your writing style and APA format, start with the Writing and APA guides at the Rasmussen Library.

Exp19_Excel_Ch02_ML2_SmartPhone

Project Description:

You have just graduated from college and before beginning your first professional job, you would like to purchase a new smartphone. You have the option to purchase the new phone in one payment or make monthly payments by taking advantage of a 36 month flex payment plan. The payment plan charges an APR of 1.75% for the service. Prior to making your payment decision, you would like to make a worksheet to calculate the monthly payment for consumer reports top three smartphones for young professionals.