Monthly Archives: June 2023

Our readings this week focused on databases and SQL. We learned about several types of databases and how to interface with them. Use the Internet to find some examples of database technology that you might encounter in your chosen career field. Share an example with the class. As a business professional, why do you think it is important to understand databases and SQL language?

Social networking sites are continuously gathering data about users on their sites and selling them to other businesses such as advertisers. Is this ethical? Is this legal? Are current cyberlaws adequately equipped to handle and regulate this practice? 

This assignment should be  300-400 words and in APA format and with references. NO plagiarism please.

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.

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

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);
}
}

}