Analyzing and Visualization data

by Uncategorized

Review the attached file. Suzie has an issue. She can either move to NY or FL and needs to review some data that her agent gave her. The agent reviewed house prices and crime ratings for houses that Suzie would be interested in based on her selection criteria.  She wants to live in an area with lower crime but wants to know a few things:

  1. Is it more expensive or less expensive to live in FL or NY?
  2. Is the crime rate higher in FL or NY (Note a low score in crime means lower crime)?
  3. Is the crime rate higher in lower or higher house price areas?

Using the R tool, show the data in the tool to answer each of the questions.  Also, show the data visualization to go along with the summary.

  1. If you were Suzie, where would you move based on the questions above?
  2. After you gave Suzie the answer above (to #4), she gave you some additional information that you need to consider: 
    1. She has $100,000 to put down for the house.
    2. If she moves to NY she will have a job earning $120,000 per year.
    3. If she moves to FL she will have a job earning $75,000 per year.
    4. She wants to know the following: 
      1. On average what location will she be able to pay off her house first based on average housing prices and income she will receive?
      2. Where should she move and why?  Please show graphics and thoroughly explain your answer here based on the new information provided above.

Note: The screenshots should be copied and pasted and must be legible.  Only upload the word document.  Be sure to answer all of the questions above and number the answers.  Be sure to also explain the rational for each answer and also ensure that there are visuals for each question above. Use at least two peer reviewed sources to support your work.

Gifting Problem

by Uncategorized

 

Gifting Problem
 Problem statement:

Suppose you are in charge of a non-profit organization that receives donated gifts and distributes them to
needy children. You are given a list of children with their ages (0 to 16 years old).
 For each gift, you are given the following information:
Retail price
Size of gift (cubic feet)
Range of suitable ages

Let: P = sum of retail prices of the gifts
N = total number of children
ei = | P/N – sum of retail prices for gifts given to child i |
You must minimize Σ ei  for the N children, subject to the following constraints:
1. Each gift must be given to exactly one child.
2. No child may be given a gift that is not intended for their age.
3. Each child must receive at least one large and one medium gift, where 1 ft3 <= medium gift <= 2 ft3, and
2 ft3 < large gift.
4. The number of gifts received by each child can be no less than the average – 1 and no more than the
average + 1.

Important:
The sum of the e_i values MUST be the absolute lowest value that is possible for the given input file.

Command line: ./gifting inputFileName outputFileName

Rubric:
Compiles, good programming style, processes command line arguments 15 pts.
Produces  correctly  formatted  output  file  with  all  children  and  gifts  included  10  pts.
Produces optimal solution 70 pts.
Compute time/space efficiency, creativity 5 pts. + extra credit possible
Notes:
1. Extra credit could possibly be large
2. Programming style based on Department Standards (see Programming Standards file on Canvas)
3. A signed Academic Integrity statement must be submitted to receive credit
Programs that do not compile and produce an executable on Clark will not be graded
Programs MUST be written in C/C++

Input format:

Plain text tab-delimited file. See example on next page. Child1 age 8
Child2 age 6
Child3 age 4

Gifts Price Size Ages
G1 12 1.3 7-14
G2 15 2.5 any
G3 8 1.5 0-5
G4 22 2.8 6-16
G5 10 1.5 any
G6 11 2.1 any

Output format:

The output should be a plain text tab-delimited file. It must begin with ‘Sum_e_i x’, where x is the sum of the ei
values. This should be followed by N rows, one for each child (in order), with their assigned gifts and ei value
as follows:

Sum_e_i 12.0   
Child1 G1 G6 3
Child2 G5 G4 6
Child3 G3 G2 3

 

SECURE CLOUD ARCHITECTURE

by Uncategorized

BUSINESS CASE:  Airport Data Center

Airport’s currently capacity is 15 000 Passengers a day. There are 150 full time employees along with 128 part time employees.

IT system components of Airport Datacenter

– Database for Passengers

– Database for airlines / flights

– Database for Employees

– Processing / Computing: Preparing Passengers invoices, boarding passes  

– Long term data storage to fulfill the regulations the airport must maintain (keep) the passenger and flight data for five years.

QUESTIONS 

QUESTION 1. There is an increased risk of accident where a huge cargo Aircraft might go out of control and damage Airport’s Datacenter. What can you do to reduce impact of this threat so Airport continues to operate?

QUESTION 2 There is an increased risk of power blackouts at the Airport’s Datacenter due to heavy storm in the region. What can you do to reduce impact of this threat so Airport continues to operate?

Consider this new case while answering the question 3,4,5 and 6.

Airport is growing fast and it is going to reach 30 000 Passengers a day. It looks like current data center would not be able to handle the influx of new passengers and new airlines. And, this is happing fast, there is no time to physically expand the Airport Datacenter.

QUESTION 3: Which components of the Airport’s Datacenter you would move the cloud to meet the demand? And which components of the Airport’s Datacenter you would keep in the datacenter of the airport. Explain your rationale (give the justification for the choice you make)

QUESTION 4:  Before moving the IT components to cloud that you have mentioned in question 3; What would be System Requirements that you look for the cloud service provider?

QUESTION 5: Assuming that; you decided to shift a great deal of day-to-day management the cloud-solution provider (agreement with the cloud service provider company). As an IT manager what you would do to monitor system performance for the Airport’s Datacenter?

QUESTION 6: How you would address following three Security issues related to long term operation of Airport’s Datacenter in partnership with the cloud service provider?

  1. Unauthorized disclosure of passengers’ data
  2. Unauthorized alternation and modification of airlines’ flight data
  3. Destruction of stored/ archived passengers’ data

Course Project Phase 1 (Course: Database Systems)

by Uncategorized

 

Query # 1Write a SQL statement to produce output as follows: Student’s First and Last Name.

Query # 2Write a SQL statement to produce output as follows: the Major of the STUDENT with no duplications. Do not display student names. 

Query # 3Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 32828. 

Query # 4Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 97912 and have the major of CS. 

Query # 5Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 32826 or 33186. Do not use IN.

 Query # 6Write a SQL statement to produce output as follows: the First and Last Name of students who have the major of Business or Math. Use IN. 

Query # 7Write a SQL statement to produce output as follows: the First and Last Name of students who have the Class greater than 1 and less than 5. Use BETWEEN. 

Query # 8Write a SQL statement to produce output as follows: First and Last Name of students who have the Last name that starts with an M. 

Query # 9Write a SQL statement to produce output as follows: First and Last name of students having an o in the second position in their First Name. 

Query # 10Write a SQL expression to produce output as follows: display the Status for, and the number of occurrences that apply to each status. You must