Monthly Archives: January 2024

Have three MySQL questions

The scenario:

The Prime National Properties Group is considering selling some of its educational facilities. The facilities have been tracked in an Access database. Shelly Williams, the President of the company, has asked you to prepare a report. Import the Access data in the file Facilities_Data as a table into Excel. Using the PMT function, calculate the monthly payments the company could expect. The company would charge an 8% rate over 10 years. The result should be a positive number. Mr. Williams also asked you to calculate an extra processing fee for monthly loan payments using the IF function. If a monthly loan payment is less than $6000, the company would charge a processing fee of $150; otherwise, there would be no processing fee. Filter the rows to display only those facilities where there is a $0 processing fee. Hide all of the address fields and the processing fee column. Save the Excel file as Lastname_Firstname_Educational_Facilities

For this assignment, you will need the following files:

New blank Excel workbook

Facilities_Data

Educational_Report

You will save your files as:

Lastname_Firstname_Educational_Facilities

Lastname_Firstname_Educational_Report

1. Open the Word document Educational_Report, and then save the file as Lastname_Firstname_Educational_Report
2. Add a cover page of your choice, and then complete the content controls on the cover page.
3. In the report, format headings as Level 1 or Level 2, and then insert a table of contents on a new page.
4. In the worksheet, hide all of the address fields and the processing fee column
5. paste the Excel data into the Word document.
6. Add an appropriate heading formatted as Level 1, and then update the table of contents.
7. In each file, insert the your name as a field in the footer

Upload the completed assignment files in the Assignment area. 

1. Read the narrative on Acme Electric, LLC.
2. Create a domain model class diagram for Acme Electric, LLC’s proposed Job Management Application.
3. Using Lucidchart
4. saved as PDF 

Acme Enterprise is a private company that is gearing up for an initial public offering (IPO). Prior to going public Acme must be in compliance with: GDPR, PCI DSS, and SOX. Acme is in the water purification business with new technologies that purify water in any form whether it is sewage, ocean, lake etc. 

Part of its IPO process is to show due diligence and due care. Acme has identified your team to conduct a risk assessment and analysis of its information technology infrastructure to uncover any threats and exposures and provide mitigations and controls to reduce those uncovered threat/exposures, so it can have a successful IPO. 

Using the Network Infrastructure design of the Acme Enterprise you are to assess risk of Acme’s:

1. Perimeter Security

2. Network Security

3. Endpoint Security

4. Application Security

5. Data Security

6. Operations

7. Policy Management

You are tasked with creating a weather data collection program that asks the user for data, and then uses that data to output alerts to the user when certain conditions are met.

The data that is to be collected by the program includes:

• Temperature in either Fahrenheit or Celisius
• Percent chance of precipitation. (How great a chance that water will fall from the sky in some form.)
• Percent Humidity.
• Time of Sunrise and Sunset.
• Wind speed.

With this data the program should send out to the user the following alerts when the conditions are met.

• If temperature is above 90 it is a heat advisory, if above 105 it is a heat warning, if below 32 it is a freeze advisory, if below 20 it is a freeze warning.
• If precipitation is < 25 % than it is a low chance, if it is between 25 % and 75 % chance then it is a decent chance and if it is greater than 75 % then it is a likely chance of rain. (Pair this with temperature though. If its below freezing it won’t be rain but snow that comes down)
• If about 80 degrees with low humidity and no precipitation then it is a fire warning.
• If wind speed is greater than 40MPH then it is a wind advisory. If above 60MPH then it is a wind warning.

There are also a few checks and balances possible.

• Sunrise should never happen before 5AM and after 8AM
• Sunset should never happen before 5PM and after 8PM
• Obviously anything involving percentages should never go above 100% or below 0%

 These days, many people are working remotely and working remotely can bring new challenges. List 5 “new” physical security challenges that work remotely entails? 

Simple, No plagiarism

Due: Wednesday 18/11/2020 by 4:00 PM EST

1. Title page, abstract, table of contents, list of figures, list of tables are all not required in the discussion forums.  All other aspects of APA (citations, list of references, correct spacing & formatting, etc.) are required to receive full credit
2. Each question should be researched and supported with some peer-reviewed sources other than or in addition to your textbook

Intellectual Property Rights

For this weeks discussion consider the following questions:

1. What are Intellectual Property Rights
2.   Why are they important?
3.   What countries are the worst offenders for not protecting Intellectual Property Rights?
4.   Would you do business with an organization in a country that did not adhere to Intellectual Property protection? Explain your answer.
5. What are the advantages to an organization to filing a patent?

Find a recent article that relates to this week’s topic and post a summary of that article and how it relates to this week’s lesson.

Post your reply by Wednesday at midnight. Your response should be at least 200 words and appropriately cite your resources.

Respond to two of your classmates by Sunday at midnight. Your responses should be at least 100 words and should be substantive. You should offer additional resources, insight, or other helpful feedback. A simple “I like your post” will result in a 0.

You will not be able to see other posts until you make your first post.

Not more than 350 words total. Respond to at least two other students (150 words each peer)!!

2. Two (2) paragraphs (350 Words total) discussion response to main DQ questions. In addition, respond with two (2) students/Peers to Peer (identify peers) or two classmates. The responses should 150 words each and must focus on the discussion topic above. Examine related issues, ask questions, provide hypothesis and/or situation(s). A peer response may not be to a peer already responded to more than twice.

topic-  Should we allow facial recognition at sporting events? What about shopping malls?

In the second milestone writing assignment, you will analyze asymmetric and symmetric encryption.  Evaluate the differences between the two of them and which one that you would determine is the most secure.  The writing assignment requires a minimum of two written pages to evaluate the history.  You must use a minimum of three scholarly articles to complete the assignment.  The assignment must be properly APA formatted with a separate title and reference page. 

evaluate the history of the Data Encryption Standard (DES) and then how it has  transformed cryptography with the advancement of triple DES. You must use at least one scholarly resource.  Every discussion posting must be properly APA formatted.

Use the textbook for added reference