Scenario

Always Fresh wants to ensure its computers comply with a standard security baseline and are regularly scanned for vulnerabilities. You choose to use the Microsoft Security Compliance Toolkit to assess the basic security for all of your Windows computers, and use OpenVAS to perform vulnerability scans.

Tasks

Develop a procedure guide to ensure that a computer adheres to a standard security baseline and has no known vulnerabilities.

For each application, fill in details for the following general steps:

1. Acquire and install the application.

2. Scan computers.

3. Review scan results.

4. Identify issues you need to address.

5. Document the steps to address each issue.

Requirement: 2 Pages + 2 resources.

NoSQL database system simulation or different systems comparison report

Ref websites:

https://www.mongodb.com/nosql-explained

https://bigdata-madesimple.com/18-free-and-widely-used-open-source-nosql-databases/

Cover page with Short introduction of what kind of tools used and the possible simulation process (with screen shot), and short comparison/discussion, final concluding

• MongoDB. This highly scalable and agile NoSQL database is an amazing performing system. …
• Redis. This is an open source, key-value store of an advanced level. …
• Couch DB
• RavenDB. …
• MemcacheDB
• Riak
• Neo4j
• HBASE

Just choose one, have a simulation and write the simulated report, must including lab screen in your report

Note: If you cannot do it, please do some articles reviewing for NoSQL, such as Comparison between different NoSQLs

Exp19_Excel_Ch08_CapAssessment_Employee_Satisfaction

Project Description:

You work as a data analyst for Camino Marketing, a U.S.-based web marketing company. You have been asked to conduct an employee satisfaction survey. As part of the survey, you will collect sample data to help provide insight into employee salaries, productivity within the three national offices, and to predict the growth of the New York office’s client base by 2025.

1

Start Excel. Download and open   the file named Exp19_Excel_Ch08_CapAssessment_EmployeeSatisfaction.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

2

Ensure the Employee Satisfaction   worksheet is active, then use the FREQUENCY function to calculate the   frequency distribution of job satisfaction in column D. Place your results in   the range G5:G9.

3

Enter a function in cell G12 to   calculate the standard deviation of column c.

4

Enter a function in cell G13 to   calculate the variance between salaries. 

5

Enter a function in cell G14 to   calculate the Covariance of the salaries and job satisfaction in the data   set. Note this is a sample of data not a population.

6

Enter a function in cell F17 to   calculate the correlation coefficient between employee salary and job   satisfaction.

7

Ensure the Data Analysis ToolPak   add-in is active. Use the Data Analysis ToolPak to create a histogram based   on the salaries in column C. Use the range I4:I9 as the Bin Range. Ensure   that Cumulative percentage, column labels, and chart output are included in   the results. Place the results in cell K4. Edit the result text in cell K4 to   display   Salary, if   necessary.

8

Ensure the Office_Data worksheet   is active. Use the Data Analysis ToolPak to perform a single factor ANOVA on   the range C3:E35. Place the results starting in cell G3. Be sure to include   column labels. Resize columns G:M as needed.

9

Create a Forecast Sheet that   depicts year over year growth in customer growth. Set the Forecast end year   as 2025 and place the results on a new worksheet named 2025Forecast.

10

Ensure the Customers worksheet   is active then create a scatter plot chart that places the Years on the X   axis and the Clients on the Y axis. Add a linear trendline to the chart that   also shows the Equation and the R-square. Add the title Customer   Growth.

11

Enter a function in cell E4 to   calculate the intercept of the linear trendline created in the prior step.

12

Enter a function in cell F4 to   calculate the Slope of the linear trendline.

13

Enter a function in cell G4 to   calculate the R-square of the linear trendline.

14

Enter a function in cell H4 to   calculate the Standard Error. 

15

Use the FORECAST.LINEAR function   in cell E7 to the total number of customers by the end of 2021. 

16

Complete your analysis by added   formulas in the range F7:G7 to calculate the high and low thresholds of the   forecast.

17

Save and close Exp19_Excel_Ch08_CapAssessment_EmployeeSatisfaction.xlsx.   Exit Excel. Submit the file as directed.

EXP19_Excel_Ch04_Cap_TechSupport

Please review the information in the attached file

 Write one SQL query to calculate the minimum  salary for all employees.  

I am doing in single person so choose 1 person 20 Tables
I include the template given by the professor. Please do not copy from any sources .

NO PLAGIARISM
ONLY RESPONSE WHO CAN DO IT 

 Project
Can be any business other than a bicycle shop (sales/repair)
1 Person 20 Tables
2 People 38 Tables
3 People 56 Tables
4 People 74 Tables
(Average 5 Columns per table)
Should be normalized to 3rd Normal Form
1 (per person) instance where 1st, 2nd, or 3rd normal form is  violated, give a detailed explanation as to why you designed this  violation (you can have more than one, but it must be explained)
Create Select/Insert/Update/Delete statements for each table (other than  many-to-many tables)
Create at least 12 business rules, 10 should be built into the design (Per person)
Naming convention – explain the naming convention you used.
Data Dictionary
10 rows of dummy data in each table (where possible)
DDL Scripts for each table, PK, and FK
Using https://app.diagrams.net/ create the ERD using Crow’s Foot Notation (No other Notation will be accepted)
If you are working as a team, make sure it is obvious who created which pieces. Color code the ERD, showing who did what.
One person should submit the project for the team.
instpubs.sql
instnwnd.sql
Chinook_SqlServer.sql
Adventureworks.sql
Data Dictionary Template.xlsx
  

you have to work on mp3 base code file

Check Attachment for project details

Assignment Content

1. STOP: (1) Have you watched the HW video on APA 7 Basics and Cover Page? (2) IF you were absent, have you watched the class recording? Do not continue to the assignment until these things are complete.    ASSIGNMENT Step 1, Brainstorm: Think about your field of study as a master’s student. Use one of the two methods taught in class and find two news articles that report on relevant problems related to the industry associated with your master’s degree program (think about scandals within the last 5 years). Come up with two examples using the format below in a simple Word document, using APA 7 Basics and an APA 7 cover page learned through the HW video (see p. 20 in Foundations for a sample cover page) Step 2, Create your Word Document and Answer Questions (it should look similar to p. 5 in Foundations): FOR EXAMPLE: If my major is public health or even education, I would come up with something like Issue/Problem 1 below (MPH students, you cannot use this as your own). We have started one together in class, so you must complete what you started in class and find a second research problem proposal:   Issue/Problem 1: Depression and anxiety among young adults  1) People Involved: College students, parents 2) Link to Article: https://www.mayoclinichealthsystem.org/hometown-health/speaking-of-health/college-students-and-depression 3) My Research Question: What have researchers learned about the impact of COVID 19 on depression and anxiety among young adult students?   I would then fill out my second Problem proposal below:  Issue/Problem 2: 1) People Involved:  2) Link to Article:  3) My Research Question: What have researchers learned about Grading: Cover/Title Page = 40 pts Issue/Problem 1 = 30 pts Issue/Problem 2 = 30 pts