please write a few words regarding the basic requirements and process of machine learning. Specifically about the role of parameter tuning that makes ML different form statistical modeling.

This has to be in APA format

This is a Database Programming course. This course covers advanced topics in databases. It starts by reviewing basic knowledge on databases and ends with advanced database concepts like security.

In this project, you will use the knowledge you acquired throughout the course to build a simple database and query it to extract information from it. You will create tables and relationships among them, in addition to the necessary keys and indexes. The next step will be to populate the database with suitable data. Populating the tables with sufficient and appropriate example data is an important step in testing and validating your design. When your database is ready, you will write SQL queries to retrieve information.

Note: This assignment was created with MySQL in mind. Therefore, dates, numbers, etc. have been set up with that tool in mind.

Upon completion of this project, you will be able to:

• Write SQL queries to create tables
• Write SQL queries to create relationships among tables
• Identify indexes and create them in a database
• Write queries to extract important information from a database

Prompt

In this project you will build a database for a public library. This database is aimed to collect and analyze information about the clients’ reading interests. The project concentrates only on books and the clients’ interests in books. The analyses that will result from this project will be used by the library’s management to decide on the future purchasing policy.

A. Write the SQL statements in order to create the tables for the database. Use the Entity Relationship Diagram (ERD) of the database shown in Figure 1. For simplicity, we are assuming in this project that a book cannot be written by more than one author. You need to create the tables as well as the required constraints, including the keys (primary and foreign), and the relationships between table.

Use the attach document to complete this assignment.

Assignment

Part 1: Describe core Azure concepts 

Part 2: Describe core Azure services 

Part 3: Describe core solutions and management tools on Azure

You need to follow the following steps by reading below links for part 1, part2 and part 3. 

1- Read 

Part 1(https://docs.microsoft.com/en-us/learn/paths/az-900-describe-cloud-concepts/ ), 

Part 2(https://docs.microsoft.com/en-us/learn/paths/az-900-describe-core-azure-services/ ),

Part3(https://docs.microsoft.com/en-us/learn/paths/az-900-describe-core-solutions-management-tools-azure/ ) 

of the Azure Certification Documentation 

2) Prepare a report using the following format # 

sections 

1. APA 7th Edition Title Page 

2. Executive Summary 

3. Table of Contents 

4. Introduction 

5. Azure subscriptions and accounts suggestions for University 

6. Azure services suggestions for University 

7. Azure resource management suggestions for University 

8. Conclusion

Note:  4 to 5 pages report required with title page, table of contents and references excluded with page count.

44.  SELECT Dept_name, Dept_Mail_Box, Dept_Phone, Emp_Num

45. SELECT Prod_SKU, Prod_Descript, Prod_Type, Prod_Base, Prod_Category, Prod_Price

46. SELECT Emp_Fname, Emp_Lname, Emp_Email

47. SELECT Emp_Fname, Emp_Lname, Emp_Phone, Emp_Title, Dept_Num

48. SELECT e.Emp_Fname, e.Emp_Lname, s.Sal_From, s.Sal_End, s.Sal_Amount

49. SELECT c.Cust_Fname, c.Cust_Lname, c.Cust_Street, c.Cust_City, c.Cust_State, c.Cust_Zip

50. SELECT e.Emp_Num, e.Emp_Lname, e.Emp_Email, e.Emp_Title, d.Dept_Name

51. SELECT b.Brand_Name, COUNT(p.Prod_SKU) AS NUMPRODUCTS

52. SELECT Prod_Category, COUNT(Prod_SKU) AS NUMPRODUCTS

53. SELECT Prod_Base, Prod_Type, COUNT(Prod_SKU) AS NUMPRODUCTS

54. SELECT Brand_ID, SUM(Prod_QOH) AS TOTALINVENTORY

55. SELECT b.Brand_ID, b.Brand_Name, AVG(p.Prod_Price) AS AVGPRICE

56. SELECT Dept_Num, MAX(Emp_Hiredate) AS MOSTRECENT

57. SELECT e.Emp_Num, e.Emp_Fname, e.Emp_Lname, MAX(s.Sal_Amount) AS LARGESTSALARY

58. SELECT c.Cust_Code, c.Cust_Fname, c.Cust_Lname, SUM(i.Inv_Total) AS TOTALINVOICES

 The security program has been a huge success. Several of the PCS government clients have expressed their appreciation and increased confidence in the company’s ability to protect their program data and assets. Your company is now in the continuous monitoring phase and your information security analysts are performing routine assessments on the servers and workstations.Based on your research for Unit 8:

• Describe the importance of assessments in system and application security.
• Describe some of the major challenges with this area of security and address why the job is never done.
• Review the results of the vulnerability scan provided by one of your analysts for a client’s system. Explain ten of the failures found on the client system and how the PCS security program prevents these problems on the corporate network.
• Conclude by discussing the relationship between assessments and the importance it has in continuous monitoring.

The requirements for your assignment are:

• 1-2-page APA paper excluding title and reference pages
• Provide at least two references and in-text citations in APA format
• College level writing

Refer to the attached document for the grading rubric. 

Exp19_Excel_Ch01_ML2_Sales

Exp19 Excel Ch01 ML2 Sales

Excel Chapter 1 Mid-Level 2 – Sales

Project Description:

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price 

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

The owners of the   house on 386 East Elm Street took their house off the market. You want to delete   that row since it did not sell.
 

  Delete row 8, which has incomplete sales data.

You want to assign a   property ID to each listing. The code will have the year 2021 with a   sequential number.
 

  Type 2021-001 in cell A5 and use Auto Fill to complete the   series to assign a property ID to each property in the range A6:A12.

Real estate agents   study the number of days houses are on the market. In some cases, the longer   a house is on the market, it might indicate the asking price is too high.
 

  Enter a formula in cell C5 that calculates the number of days the first house   was on the market by subtracting the date listed from the date sold. Copy the   formula to the range C6:C12.

Monetary values look   better when they are formatted to display the dollar signs. Because all   monetary values are whole numbers, you will decrease the decimal points to   avoid columns where all the data ends in .00.
 

  Format the list prices and sold prices in the range F5:G12 with Accounting   Number Format with zero decimal places.

To analyze the real   estate market, it is helpful to calculate the selling prices as a percentage   of the list price. For example, the second house was listed for $500,250, but   it sold for only $400,125. Therefore, the sale percentage of the list price   is .7999 or 79.99%.
 

  Enter a formula in cell H5 that calculates the sales price percentage of the   list price for the first house by dividing the sold price by the list price.   Copy the formula to the range H6:H12.

The calculated   percentages need to be formatted with the percent symbol rather than   displaying the values as raw numbers.
 

  Format the values in the range H5:H12 with Percent Style with two decimal   places.

Currently, the labels   on row 4 are hard to read. You will wrap the headings within each cell to   improve readability.
 

  Wrap the headings in the range A4:H4.

For better sequencing   of columns, you want to display the Days on Market column after the two   columns containing the dates.
 

  Insert a new column between the Date   Sold and List Price columns.   Move the Days on Market data to the   new blank column F by moving the range C4:C12 to F4:F12. Delete column C.

You notice the list   contains a wrong date and wrong list price that need to be corrected.
 

  Edit the list date of the 41 Chestnut   Circle house to be 4/22/2021. Edit the list price of the   house on Amsterdam Drive to be $355,000.

Increasing the height   of the rows of data and centering the data vertically between the top and   bottom cell margins will make it easier for the other agents to review the   data.
 

  Select the property rows (rows 5:12), set a 25 row height, and apply   Middle Align.

Displaying borders   helps separate the property listings.
 

  Apply the All Borders border style to the range A4:H12.

You want to improve   the alignment of number of days on market below the column label.
 

  Apply Align Right and increase the indent two times on the days on market   formula results in the range E5:E12.

The widths of the   columns containing the Days on Market, List Price, and Sold Price data need   to be adjusted for better appearance.
 

  Set the Days on Market column width to 9. Set the List Price and Sold   Price column widths to 11.86.

The property listings   dataset is small. To improve readability on the printed copy for the other   real estate agents, you will increase the scaling.
 

  Apply 120% scaling.

You don’t need the   data on the Properties sheet but you do want to insert another sheet for   formulas.
 

  Delete the Properties sheet and insert a new sheet named Formulas.

You want to copy the   original data to the new sheet so that you can modify the duplicated data.
 

  Use the Select All feature to select all data on the Houses Sold worksheet   and copy it to the Formulas worksheet.

You do not want to   display the columns containing dates on the new worksheet.
 

  Hide the Date Listed and Date Sold columns in the Formulas worksheet.

You want to review   the formulas within the worksheet and prepare the Formulas sheet to be   printed.
 

  Display cell formulas. Set options to print row and column headings. Set 6.86   column width for column E and 6 for column H.

You want to apply   page setup options to both sheets, so you need to group the sheets first.
 

  Group the two worksheets. Select Landscape orientation. Center the page   horizontally and vertically between the margins.

With both worksheets   still grouped, insert a footer with the text Exploring Series on the left side,   the sheet name code in the center, and the file name code on the right side.

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

Write code for the application that allows users to calculate the expected cost of a trip as follows: User can enter anticipated miles User can enter anticipated cost of gas per gallon The application should: Provide interface options to allow the user to calculate anticipated cost and exit the application Calculate and display the approximate cost, including oil change Create a Drop box List for the application’s applet to include: Beginning locations (at least six) Destination locations (at least six) Vehicle size (compact, mid, luxury, SUV) Gas type (leaded, unleaded, super unleaded, diesel) Also create the following: A field for approximate miles A field for cost of gas per gallon A Submit button A Clear button Now that you have created most of the code as well as the front end features and buttons, create a calculator function to enable users to calculate their own costs if they choose. Be sure to follow the same format that you have been using for the previous assignments. This week you create the final piece of your Java Project. Follow the steps below to finish your project: Create an interface with the motif look and feel that allows the user to enter and record trips taken and store them in a data file on a floppy disk. Fields should include: Trip date Start destination Ending destination Mileage Cost

Documentation must contain overview, product objectives, product features and FAQs that can be answered.

 Answer each these questions in a paragraph with at least five sentences: Include the question and number your responses accordingly. Provide a citation for each answer.

1. Describe Digital Literacy (how to know what is real on the web). 

2. None of these people exist. What does this mean to you?

3. Why is Wikipedia more reliable than a paper encyclopedia?

4. How useful are crowd sources answers?

5. What are some drawbacks to crowd sourced answers?

6. Do people generally utilize the diversity of sources on the Internet effectively?

7. How reliant are we and how reliant should we be on getting our news from social media?

8. How do humans remain vigilant when we turn over authority to computers? Have you tried to navigate without gps?

9. If models are simplifications or reality, why do we rely on them?

10. Why was this model, used by Amazon for hiring, wrong?

11. Why did Skynet declare war on the human race?

Objectives

The student will be able to analyze an organizational task/scenario and select the appropriate information system or application software to satisfy the organizational requirements. The student will be able to create basic Office Support System documents to satisfy some of those requirements. The student will also be able to demonstrate their skill with Internet based research methods and find relevant/reliable information for a variety of purposes.

Assignment Overview

• Imagine you are employed as a Help Desk Support person working for “XYZ Company”. Today you are tasked with logging and resolving your first IT Support Ticket on your own.
• You will need to record a variety of information about the issue and come up with a resolution based on your knowledge of Computer Information Systems learned in readings/videos throughout the course.

Case Background

Meet Pavan. Pavan is a new employee at “XYZ Company”. Pavan will be working in the Human Resources Department as an Human Resources (HR) Generalist. 

Pavan does not yet have any hardware or software to begin working and has contacted you at Help Desk Support to get set up. Pavan mentioned that each of the other HR Generalists have a laptop computer, a docking station, two monitors, a keyboard, and mouse.

You also know that Pavan will need access to Microsoft Office 365 for accessing company documents/emails and QuickBooks for recording employee hours and pay information.

Pavan would like to get his access set up as soon as possible because he already has employees reaching out to him for assistance with pay issues and his boss asking when he can get started.

Case Requirements

After reading the case background and class materials, fill in the IT Support Ticket Template provided with relevant information.

1. Give the ticket issue a name/title and issue description.
2. List the hardware, software, or other components that are part of this issue. Are there any items you think Pavan or you might be forgetting (maybe ERP access)? If so, feel free to use your imagination and to add your ideas to your ticket. Consider what you have learned in each chapter and how it can be helpful with this issue.
3. Name the people and processes impacted by Pavan’s issue.
   1. Pavan is the one with the issue but consider others who might be impacted by him not being able to do his work with Payroll and what department they might be in. 
4. Go do some internet research to price a few of the items Pavan needs and enter these numbers into the budget.
   1. Note that all answers will vary and there is no right or wrong number here. The important component of this part of the assignment is that you can identify hardware and software and do some basic research to find those resources.
5. Once you have considered all the components that are a part of this issue and identified anything needed to set up Pavan, please write Pavan an email in the second tab of the template (Part 2 – Resolution).
   1. Ensure you let Pavan know that you have resolved his issue and are closing his ticket.
   2. Also let him know what you did to resolve his issue successfully.