1) Define the following database terms: relational database, table, record, and field. 

2) What is SQL and what is it used for? Can you give some examples of SQL statements and explain what results are obtained from these statements?

3) Read the Week 7 iLab instructions and discuss the expectations you have regarding this lab. Do you see the importance of being able to access a database from a script or program? How did your actual lab experiences meet your expectations? Are there specific insights or challenges you encountered that you would like to share with the class?

What did you learn about VBScript database access and SQL commands in completing this lab?

 Homework Report Format: At the end of each lecture, students will prepare a short (~2-3 pages, 12-point single space) report that addresses as many of the following questions as are relevant: • Describe the market sector or sub-space covered in this lecture. • What data science related skills and technologies are commonly used in this sector?  I will provide the rest of questions and information, after you decide to take this assignment.

Assessment: The rubric for assessment is: content and responsiveness to questions (80%), comprehension of lecture material (15%), writing style (5%).

I need to generate a report of following services from multiple aws accounts :

I have a file named accounts_list which has all AWS account id’s with in the organization.

I have to run a script to loop through all the aws accounts and get the following information. 

VPC name

CIDR block 

list of VPC peering

list of transit gateway connection

list of virtual private gateway

Payroll Lab

You will be taking in a file (payroll.txt) which details a number of departments (at least 1) and in each department are a set of employees (each department will have at least 1 employee or it would not appear on the payroll sheet). Your job is to read the file in separate out each employee and calculate the total values (hours, salary, number of employees) for each department and in each category (F1, F2, F3, F4). In your final submission please include the .cpp file which should work for any kind of payroll file I supply (which will naturally match the format of the examples below). Be sure to indicate in your submission text if you have attempted any of the bonus points .

An example file:

The IT Department
Bill 8 7 8 9 7 F1
Bob 205103 0.08 F3
Betty 8 8 7 8 8 F2
Brandon 10 10 9 6 9 F2
Brad 9 8 10 9 9 4 1 F4

The Sales Department
Kyle 88840 0.105 F3
Tyler 105203 0.085 F3
Konner 8 6 7 6 9 F2
Sam 309011 0.045 F3
Kent 9 8 9 9 9 0 0 F4
EOF

An additional example file:

The Sales Department
Mike 5 6 1 3 5 F1
Mark 98103 0.115 F3
Jill 8 8 8 8 8 F2

Frank 106101 0.095 F3

Mark 76881 0.091 F3

Department of Records
Konner 8 6 7 6 9 F2
Tammy 7 3 7 2 8 F1

Anika 8 8 8 8 8 F2

Marta 1 0 0 5 2 F1
Kent 9 8 9 9 9 0 0 F4
EOF

Last in the row after the hours comes the pay grade (F1, F2, F3, F4). The number of hours recorded is based on the pay grade of the employee. F1 and F2s will have 5 numbers for their hours. F3s are commission based where a sales amount and a commission percentage is given. F3s are also assumed to work 30 hours if their commission is 10% or below and 40 hours if their commission is above 10%. F4s will have 7 numbers (as they are on-call during the weekend). Each of the pay grades will also have different pay calculations which are as follows:

F1 = The total number of hours * 11.25
F2 = (The total number of hours – 35) * 18.95 + 400
F3 = The total sales amount * the commission rate
F4 = The first 5 hourly totals * 22.55 + Any weekend hourly totals (the last 2) * 48.75

Your output to the screen should start with the department name, followed by the total pay for all of the employees, then the total number of hours, and the total number of employees. After that you should have a breakdown of each category of employee: F1 total pay and total hours, F2 total pay and total hours…

Each department will have at least 1 employee and each department will contain the word “Department.”

The IT Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Bill, Bob, Betty, Brandon, Brad 

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

The Sales Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Kyle, Tyler, Konner, Sam, Kent

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

Before coding your solution, take the time to design the program. What are the possible things that the file can have that you need to anticipate? What are the actions that you need to take (read the file, add up hours…)? Are those actions things that could be placed in separate functions? What about the function – can you guess some of the things that will happen? Such as, using substring to pull out part of a line in the file maybe using stoi to convert a string to an integer to add it to the total or creating variables to hold the employee type you find before passing it to another function. Finally, how are these functions called, what is the order and what information is passed to and from? 

Scoring Breakdown

25% program compiles and runs
30% program reads in and calculates the figures for output
10% the program is appropriately commented
35% outputs the correct information in a clear format 

5% bonus to those who can output the F# responses in a columned output like that shown above.

5% order the employees in the roster according to their F status, F1’s first, then F2’s and so on.
5% bonus to those who do a chart comparing the data at the end to show the relation between the pay grades and the amount of salary spent in each (they style of chart is up to you and more points may be given for more difficult charts (like a line chart):

B Department
F1 – 00000000
F2 – 000000
F3 – 00000
F4 – 000000000000 

K Department
F1 – 0
F2 – 0000
F3 – 0000000000
F4 – 0000000 

Or event something like this instead:

0
0 0
0 0 0
0 0 0 0
0 0 0 0
F1 F2 F3 F4

 DRAFT.

Course Outcome practiced in this unit:

IT460-4: Develop information systems by converting design specifications into data structures.

1. Include a title page and reference page.
2. Written work is provided in Standard English.
3. Provide a header for each question and answer.
4. Each question should include at least one APA reference and inline citation.
5. At least 3 pages in length, not counting the title page and reference page.

Questions:

1. What is the purpose of creating a logical process model and then a physical process model? How are they different? What information is found on the physical DFD that is not included on the logical DFD?
2. List the steps necessary transform logical models to physical models.
3. Define a structure chart and explain the importance of sequence, selection, and iteration
4. Provide an example of a structure chart you have found online (citation necessary). Explain the purpose of this chart.
5. What does a data couple depict on a structure chart? What symbols are used to depict it? What does a control couple depict on a structure chart? What symbols are used to depict it?
6. List the seven types of coupling. Give an example of good coupling and an example of bad coupling.
7. What is meant by the characteristics of fan-in and fan-out?
8. Discuss three ways to improve the quality of a structure chart.

6.   Write a program that asks the user for an ending value. Ask the user for a number. Use a for loop to calculate and display the following. 

Index and the value of the number

During each iteration of the loop the value of the number should double and add 1. Example if number is 2, the next value should be 5. The next value after that should be 11, and next would be 23.

SAVE AS midtermprogram6.cpp

——————————————-

7.   Membership Fees IncreaseA country club, which currently charges $2,500 per year for membership, has announced it will increase its membership fee by 4 percent each year for the next 6 years. Write a program that uses a loop to display the projected rates for the next 6 years.

SAVE AS midtermprogram7.cpp

at least five hundred words discussing the reasons for the two new auditing roles in Oracle 12c. Why did Oracle consider them necessary? What problems do they solve? How do they benefit companies? 

Do not copy without providing proper attribution. 

Use the five-paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaningful title.

Include at least one quote from each of 3 different articles.

Use the Research Databases available from the Danforth Library, not Google. 

Using the following link as your reference, select TWO and explain the differences

(viruses, worms, trojans, and bots).

What Is the Difference: Viruses, Worms, Trojans, and Bots?

 You are a digital forensics intern at Azorian Computer Forensics, a privately owned forensics investigations and data recovery firm in the Denver, Colorado area. Azorian has been called to a client’s site to work on a security incident involving five laptop computers. You are assisting Pat, one of Azorian’s lead investigators. Pat is working with the client’s IT security staff team leader, Marta, and an IT staff member, Suhkrit, to seize and process the five computers. Marta is overseeing the process, whereas Suhkrit is directly involved in handling the computers.

The computers must be removed from the employees’ work areas and moved to a secure location within the client’s premises. From there, you will assist Pat in preparing the computers for transporting them to the Azorian facility.

BACKGROUND

Chain of Custody

Evidence is always in the custody of someone or in secure storage. The chain of custody form documents who have the evidence in their possession at any given time. Whenever evidence is transferred from one person to another or one place to another, the chain of custody must be updated. A chain of custody document shows:

• What was collected (description, serial numbers, and so on)
• Who obtained the evidence
• Where and when it was obtained
• Who secured it
• Who had control or possession of it

The chain of custody requires that every transfer of evidence be provable that nobody else could have accessed that evidence. It is best to keep the number of transfers as low as possible.

Chain of Custody Form

Fields in a chain of custody form may include the following: 

• Case
• Reason of evidence obtained
• Name
• Title
• Address from person received
• Location obtained from
• Date/time obtained
• Item number
• Quantity
• Description

For each evidence item, include the following information:

• Item number
• Date
• Released by (signature, name, title)
• Received by (signature, name, title)
• Purpose of chain of custody

For this assignment:

1. Walk through the process of removal of computers described above from employees’ work areas to the client’s secure location and eventually to the Azorian facility. Who might have possession of the computers during each step? Design a flow chart of the process.
2. Each transfer of possession requires chain of custody documentation. Each transfer requires a signature from the person releasing the evidence and the person receiving the evidence. Include the from/to information in your diagram or flow chart.

Submission Requirements

• Format: Microsoft Word Document or PowerPoint (or compatible) or the drawing program of your choice; file saved as a PDF
• Length: 1–3 pages

Find a peer-reviewed scholarly journal article discussing big data analytics. Complete a review of the article by writing a 2-3 page overview of the article. This will be a detailed summary of the journal article, including concepts discussed and findings. Additionally, find one other source (it does not have to be a peer-reviewed journal article) that substantiates the findings in the article you are reviewing. You should use Google Scholar to find these types of articles. Once you find the article, you will read it and write a review of it.  This is considered a research article review. Your paper should meet these requirements: 

• 6 pages APA format 
• Be approximately four to six 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.
• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. 
• Be 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.