Complete a program that is designed to read an XMl file, follow an XPath to a selected node, and then list all of the text content (ignoring attributes) in the subtree rooted at the selected node, in the order that the text appeared within the original XML file.

You will be provided with the bulk of the code for this program, including the input processing to read XML and convert it into a tree structure (declared in node.h).

Your task is to supply the functions declared in extraction.h:

1. A function to walk the tree starting from its root, following an XPath to a desired node.
2. A function to extract all of the text (in the leaves of the tree) in the tree, combining it into a single string with one or more blanks separating the text strings from different nodes.

Your bodies for these functions should be written in extraction.cpp.

To run the application program, supply two command line parameters. The first will designate an XML file and the second will be the XPath to the desired node.

Example 1

./xmlextract test0.html /html/body

will print

Hello world!

Example 2

./xmlextract test1.html /html/body/p[2]

will print

world!

Example 3

./xmlextract books1.xml /rdf:RDF/pgterms:etext/dc:creator

will print

Twain, Mark, 1835-1910

Example 4

./xmlextract books1.xml /rdf:RDF/pgterms:etext[3]

will print

&pg; A History of the Early Part of the Reign of James the Second Fox, Charles

James, 1749-1806 Morley, Henry, 1822-1894 [Editor] A History of the Early Part

of the Reign of James en Great Britain -- History -- James II, 1685-1688 DA

2003-07-01 17

Please only submit new extraction.cpp file with the bodies fot the two missing functions!

I need below paraphrased so that it shows less than 10% on turnitin.com. Please provide the report.

A VPN is a Virtual Private Network that enables a remote user to have control over a

networked server or system securely. There are 3 different types of VPN servers; a Tunnel VPN, a

Transport VPN, and a Passthrough VPN. In this week’s lab was all about the difference between

secure and non-secure file transfers as well as how to configure a VPN Client to work with a

PFsense VPN Server. This is extremely important to know because being able to safely transfer files

without having them intercepted is part of what we are learning in Cybersecurity. I had issues

setting up the connection properly and then connecting the PC to the VPN. Luckily I was able to

figure it out and the accomplishment of setting up the first connection and seeing that it is up and

running is great. I do want to learn how to input codes within the command prompt without

instructions. I feel like that the basics should be taught when learning these things. The second part

of the lab was also about the secure and non-secure transfer of files but went a little more in-depth

with Wireshark. I was able to analyze the traffic coming through the VPN server through the use of

Wireshark and the filter function which was able to separate all of that traffic to whatever I

specified. Overall I learned a lot through this lab. I hope in future classes we get a more in-depth

hands-on experience of setting up these servers.

Hello

these are three assignments of UML. please check and let me know.

Exp19_Access_Ch09_Cap – Trading Cards 1.0

 #Exp19_Access_Ch09_Cap – Trading Cards 1.0

Exp19_Access_Ch09_Cap – Trading Cards 1.0

Project Description:

You and your partner Stann Dupp have a small business selling  baseball cards online through eBay. As the more computer-savvy partner;  you created an Access database with records of the cards you have in  stock. As it turns out, Stann was attempting to manage the card  inventory and ended up modifying crucial aspects of the database that  impact the general operation of the database. You will reverse those  changes and create other safeguards to protect from this happening again  in the future. The database tables may already be normalized; however,  you will examine the tables to verify.

Start Access. Open the downloaded   Access database named Exp19_Access_Ch09_Cap_Trading_Cards.accdb.  Grader has automatically added   your last name to the beginning of the  filename. Save the file to the   location where you are storing your  files.

You   will first establish relationships between the Cards, Brands,  and Rarity   tables based on the common fields that they share.
 

  Open the Relationships window. Add the Cards,   Brands, and Rarity tables to the layout.

After   creating a relationship between two tables, you will enforce  referential   integrity, which ensures that the relationship will remain  intact if/when   data is updated in either table. Furthermore, you will  ensure that all   changes to the primary key in your Cards table will  be reflected in the foreign   keys that exist in the Rarity table by  selecting the Cascade Update Related   Fields option.
 

  Create a relationship between the Cards   and Rarity tables tables, ensuring   you check the Enforce Referential   Integrity and Cascade Update   Related Fields options for the relationship.

After   also establishing the relationship between the Cards and  Brands tables, in   the same manner, you will analyze the database to  identify any flaws in the   design as well as suggested low-risk  improvements that can be made to your   database.
 

  Create a relationship between the Cards   and Brands tables, ensuring you   check the Enforce Referential   Integrity and Cascade Update   Related Fields options for the relationship. Save, and close the   Relationships window. Open the Performance   Analyzer dialog box, under All Object Types, click Select All, and then click OK.   Note the idea to relate the Cards table to the others in the database. Close   the Performance Analyzer.

You   will now provide your users with a simple and intuitive way to add and edit   cards by creating a form.
 

  Create a new form based on the Cards   table using the Form tool. Save   the form as Add or Edit Cards.   Close the form.

Now   that you have the Add or Edit Cards form created, you can add  that and the   remaining forms to a Horizontal Tab navigation form. By  doing this, you will   create a one-stop-shop for your users to view and  edit the trading cards in   the database.
 

  Create a navigation form based on the Horizontal   Tabs template. Drag the Add or   Edit Cards form to the first tab position.

Drag   the All Player Cards report to the   second tab position.

Drag   the Bowman Cards report to the   third tab position.

Drag   the Donruss Cards report to the   fourth tab position.

Drag   the Fleer Cards report to the   fifth tab position.

Drag   the Topps Cards report to the   sixth tab position.

Switch   to Form view and test the navigation form. Save the navigation form with the   default name and close it.

You   will finalize the interface for your users by hiding the  Navigation Pane so   that it is out of their way, and setting the  navigation form you created to   open automatically when the database  opens. This ensures that the user’s   experience is seamless and  straightforward.
 

  Set the database to hide the Navigation Pane and open the  navigation form   when the database opens. Close the database and reopen  it observe that the   form opens automatically.

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

refer to the attached document.

Business Scenario Company Lowkey Inc is attached.

FOLLOW ASSIGNMENT INSTRUCTIONS BASED ON LOWKEY INC PROJECT PROPOSAL THAT IS ATTACHED.

A project plan outlines recommended approaches to the use of the network, database management system, software, and cloud service technologies. Because industry best practices dictate transparency in terms of selection criteria and their importance to a specific project, a project plan draft should also include the criteria by which the recommended approaches were selected, along with the benefits to the project that each is expected to deliver.

For this assignment, you will draft a project plan for the project proposal you outlined in Week 1 (and that you updated earlier this week based on instructor feedback).

Download the Project Plan Draft.

Create a 3- to 4-page project plan draft for the business scenario that was approved by your instructor last week. You may fill out the document using Microsoft Word or use other software (such as Microsoft Excel or Microsoft Project) to create your project plan draft. Your draft must include the following items:

• Network technology recommendation(s)
• Database management system recommendation(s)
• Appropriate software application recommendation(s)
• Cloud service recommendation(s)

Submit your assignment.  

Congratulations! Your boss, Judy “Mac” McNamara, thought you did a great job on your Vulnerability Management Process recommendation and analysis of the OpenVAS vulnerability report. However, the boss doesn’t think the free OpenVAS tool will provide the high-level presentation reporting and support needed by Mercury USA. Now, Judy would like you to evaluate the leading commercial vulnerability scanner, Nessus. Fortunately, Judy had asked someone in the IT department to install and configure a 30-day evaluation copy of Nessus. She hands you a recent Nessus report from IT that has a few more systems added, and with a wry smile adds, “It looks like there’s some really bad stuff in there!”

Judy would like you to provide an analysis of the report. You decide to highlight what you think the company should address first and how you would mitigate some of the top threats. In addition, Judy wants to know your thoughts on Nessus, since it’s expensive. You now realize that you need to ensure due diligence has been performed before making a purchase recommendation to executive management.

This week, you will submit the second project, VM Scanner Background Report, based on the Nessus Report. As you are writing your report, you may want to refer back to the CEO’s video in Week 1 to make sure your analysis and recommendations align with the CEO’s priorities and concerns.

You should link your analysis to the kinds of organizational functions and data associated with a transportation company (e.g., protecting order data, customer lists, sales leads, Payment Card Industry (PCI) compliance for processing credit, proprietary software, etc.) and provide your recommendation if Mercury USA should purchase the Nessus tool. This report should be four to six pages in length and include a title/cover page. Include in-text citations and a reference page with three quality sources in a citation style of your choice.

Delete the instructional text from the template before you submit.

Project overview:

Mercury USA is a small- and medium-sized business (SMB) in the transportation sector with 400 employees. 

You’ve just been hired by Mercury USA as the first cyber threat analyst on the team and will work within the existing Information Technology department. Mercury USA has an urgent interest in addressing security vulnerabilities.

Judy “Mac” McNamara, the manager of IT services, said the chief executive officer (CEO) recently learned via a mandatory breach disclosure that a competitor was a victim of ransomware. The firm in question lost a significant amount of intellectual property and customer data and is facing expensive litigation, government fines, and loss of customer confidence. These issues are likely to result in bankruptcy.

Thus, executive management would like to prevent Mercury USA’s critical data (e.g., order data, customer lists, sales leads, Payment Card Industry (PCI) compliance for processing credit, proprietary software) from falling into the wrong hands and threatening the survival of the business.

PowerPoint_3G_Remodels

#PowerPoint3GRemodels

Project Description:

#In the following project, you will format a presentation that describes backyard remodels.

#Open   the file named Student_PowerPoint_3G_Remodels.pptx. downloaded with this project.

Change the Colors for the   presentation to Paper.

#On Slide 1, format the   background with the Stationery texture, and then change the Transparency to   30%.

#Select Slides 2 through 4, and   then apply a Solid fill to the background of the selected slides-in the fifth   column, the third color.

#On Slide 2, hide the background   graphics.

#On Slide 2, insert a Table with   2 columns and 4 rows. Apply table style Medium Style 3-Accent 1, and then   type the information below in the inserted table.
 

  Row 1, Col 1: Improvement Type; Col 2: Components
  Row 2, Col 1: Outdoor Kitchen; Col2: Barbecue, sink, bar, covered patio
  Row 3, Col 1: Swimming Pool; Col 2: Jacuzzi, pool, waterfall
  Row 4, Col 1: Fire Pit; Col 2: Fire pit, seating area, gas lines

#Change the Font Size of all of   the table text to 28. Resize the table height to 5.8″, and then   distribute the table rows. Align   the table text so that it is centered horizontally and vertically within the   cells.

In the table, change the Font   Size of the first row of text to 32. Apply a Round style Cell Bevel to the   first row. Note, depending on your version of PowerPoint, this may be called   Circle.

On Slide 3, animate the picture   using the Wipe entrance animation starting After Previous. Change the   Duration to 01.00. Apply the Split entrance animation to the bulleted list   placeholder, and then change the Effect Options to Vertical Out.

#On Slide 4, insert a Clustered   Column chart. In the worksheet, beginning in cell B1, type the following   data.
 

  In row 1, beginning in cell B1: Owner Installed, Contractor, Owner as Contractor
  In row 2, beginning in cell A2: Patio, 8000, 12000, 9500
  In row 3, beginning in cell A3: Bar, 3500, 5200, 4600
  In row 4, beginning in cell A4: Infrastructure, 5000, 9750, 8100
  In row 5, beginning in cell A5: Appliances, 3000, 4200, 3850

Apply Chart Style 8 to the   chart, and then remove the Chart Title element. Apply the Wipe entrance   animation to the chart and change the Effect Options to By Series.

On Slide 5, format the   background using solid fill color Dark Green, Background 2 and hide the   background graphics. (depending upon your version of Office, the color may be   named Dark Green, Text 2). From your downloaded project files, insert the   video p03G_Video1.mp4.

#Change the Video Height to 5 and use the Align Center and   Align Middle options to position the video. Apply the Simple Frame, Black   video style.

#On the Playback tab, change the   Video Options to Start the video Automatically. Trim the video so that the   End Time is 00:07 and then compress the media to Low Quality. (Mac users, the   Compress Media feature is not available on a Mac).

#On Slide 6, hide the background   graphics, and then format the slide background by inserting a picture from   your downloaded grader files-p03G_Backyard.jpg.   Set the Transparency to 0%

#Insert a Header & Footer on   the Notes and Handouts. Include the Date and time updated automatically, the   Page number, and a Footer with the text 3G_Remodels
  Display the document properties. As the Tags, type backyard   remodels 

Exp22_Excel_Ch07_HOE_Salaries

Project Description:

You are an assistant accountant in the Human Resources (HR) Department for Home Protection, Inc., a company that sells smart home security systems to residential customers. Home Protection, Inc., with locations in Atlanta, Boston, Chicago, and Cleveland, has a manager at each location who oversees several account representatives. You have an Excel workbook that contains names, locations, titles, hire dates, and salaries for the 16 account representatives and 4 managers. To prepare for your upcoming salary analyses, you downloaded salary data from the corporate database into the workbook. The HR director wants you to perform several tasks based on locations and job titles. You will use date functions to identify the year each employee was hired and how many years they have worked for the company. In addition, you will use logical functions to calculate annual bonus amounts. Next, you will insert math and statistical functions and a map to help analyze the data. Finally, you will review the financial aspects of automobiles purchased for each manager.

Steps to Perform:

Step

Instructions

Points    Possible

1

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

0

2

Your first task is to extract the year hired from   the hire date for each employee.
 

  In cell F7 of the 1-Date Logic worksheet, insert the YEAR function to   identify the year from the date stored in cell E7. Use the fill handle to   copy the function from cell F7 to the range F8:23 using the Fill Without   Formatting option.

5

3

Your   next task is to calculate how long each manager and representative has worked   for the company.
 

  In cell G7, insert the YEARFRAC function using the Hire Date and Last Day of   the Year. Use relative and mixed references correctly. Use the fill handle to   copy the function in cell G7 to the range G8:G23 using the Fill Without   Formatting option.

5

4

You want to identify which day of the week each   employee was hired. To do this, you will insert a WEEKDAY function to return   an integer representing the weekday.
 

  In cell H7, insert the WEEKDAY function using the Hire Date. Copy the   function from cell H7 and paste to the range H8:H23 using the No Borders   paste option. 

5

5

You   will use a custom number format to display the result as a weekday instead of   an integer.
 

  Select the range H7:H23, apply the custom number format dddd, and apply left horizontal alignment.

3

6

Column B contains the city location for each   account rep and manager. However, you also want to display the regions.   Atlanta is in the South, Boston is in the Northeast, and Chicago and   Cleveland are both in the Midwest. You will use the SWITCH function to   identify which region each city is in.
 

  In cell C7, insert the SWITCH function to identify the city in cell B7.   Switch Atlanta   for South (cell   C2), switch Boston for Northeast (cell C4), switch Chicago for Midwest (cell C3), switch Cleveland for Midwest (cell C3). Insert   city names as text strings, and use mixed references to the cells containing   the regions. Copy the function from cell C7 and paste to the range C8:C23   using the paste Formulas option.

5

7

Your   next task is to calculate the annual bonus amount for each employee. The   company uses a tiered bonus system that awards a specific percentage of   salary based on hire date.
 

  In cell J7, insert the IFS function to test if the Hire Date is before   1/1/2013. If so, the bonus is 8% of the salary. If the Hire Date is before   1/1/2018, the bonus is 4% of the salary. If the Hire Date is before 1/1/2023,   the bonus is 2% of the salary. If none of the conditions are met, the bonus   is 0. Use mixed references to the   dates in the range J2:J4 and bonus percentages in the range K2:K4. Copy the   function from cell J7 and paste it in the range J8:J23 using the paste   Formulas option.

5

8

The HR director recommends that the company pay   managers at least $80,000.
 

  In cell K7, insert an AND function that evaluates if the the Title is Manager and if the Salary is less than   $98,000. Insert the title as a text string and use a mixed reference to the   $98,000 in cell G3. Nest the AND function as the logical test within an IF   function. If the results of the AND function are true, display the text Due for a   raise. If the   results are false, display the text N/A. Use the fill handle to copy the function to the   range K8:K23 using the Fill Without Formatting option.

5

9

You   want to calculate the number of employees in each state. You set up a   worksheet with a summary section to calculate statistics by states, indicated   by the state abbreviations.
 

  Display the 2-Stats Map worksheet. In cell J3, insert the COUNTIF function to   count the number of state abbreviations in the State column that match the   state abbreviation in cell I3. Use mixed references to the range and relative   reference to the criteria state abbreviation. Copy the function from cell J3   to the range J4:J6.

5

10

Next, you want to calculate the total payroll by   summing employee salaries in each state.
 

  In cell K3, insert the SUMIF function to total the Salary column if the State   column meets the state abbreviation criteria in cell I3. Use mixed and   relative references correctly. Copy the function from cell K3 to the range   K4:K6. 

5

11

You now   want to focus on average salaries by job title. You will calculate the   average account rep salary and the average manager salary.
 

  In cell J9, insert the AVERAGEIF function to calculate the average salary if   the Title column meets the title criteria in cell H9. Use mixed and relative   references correctly. Copy the function from cell J9 to cell J10.

5

12

Now you want to focus on the summarizing data for   Account Reps hired before 1/1/2018. Specifically, you want to calculate the   total number of Account Reps.
 

  In cell J13, insert the COUNTIFS function to calculate the number of Account   Reps (cell H9) in the Title column where the date in the Hire Date column was   before 1/1/2018. Use relative references for   the two criteria range arguments and the title criteria argument in cell H9.   Type the date comparison for the second criteria argument.

5

13

The   next step is to calculate the total salary for Account Reps hired before   1/1/2018. You will use mixed references so that you can later copy the   function and change the function name for other calculations.
 

  In cell J14, insert the SUMIFS function to calculate the total amount in the   Salary column where the Title contains the job title criteria Account Rep   (cell H9) and where the date in the Hire Date column was before 1/1/2018. Use relative references for   the sum_range argument, the two criteria range arguments, and the title   criteria in cell H9. Type the date comparison for the second criteria   argument.

5

14

Copy the function from cell J14 to cell J15. In   cell J15, change the function name to AVERAGEIFS. If the original function was   created correctly with mixed and relative cell references, the modified   function should calculate the average salary for Account Reps hired before   1/1/2018.

3

15

Copy   the function from cell J15 to cell J16. In cell J16, change the function name   to MAXIFS. If the original function was   created correctly with mixed and relative cell references, the modified function   should calculate the highest salary for Account Reps hired before 1/1/2018.

3

16

Copy the function from cell J16 to cell J17. In   cell J17, change the function name to MINIFS. If the original function was created correctly   with mixed and relative cell references, the modified function should   calculate the lowest salary for Account Reps hired before 1/1/2018.

3

17

You   want to insert a map to indicate the total payroll by state.
 

  Select the ranges I2:I6 and K2:K6 and insert a filled map. Cut the map and   paste it in cell M1.

5

18

Change the map title to Payroll by State.

1

19

You   want to customize the map.
 

  Display the Format Data Series task pane and display map labels in the Best   fit only position. Apply the Diverging (3-color) series color. Change the   minimum lowest value fill color to Orange. Change the maximum highest value   fill color to Dark Red. Close the task pane.

2

20

The location managers want new company cars. The   chief financial officer has determined that the company can afford $600   monthly payments based on a 5.25% APR for three-year loans. Your first step   is to calculate the loan.
 

  Display the 3-Finance worksheet. In cell E2, insert the PV function using the   periodic rate, the number of payment periods, and a negative value for the   monthly payment.

3

21

Next,   you want to enter formulas that will calculate the beginning balance.
 

  In cell B8, enter a reference to cell E2. In cell B9, enter a reference to   cell F8. Copy the formula from cell B9 to the range B10:B43. (The results   will be correct after all other formulas and columns are completed.)

2

22

In cell C8, enter a mixed reference to B2. Copy the   formula to the range C9:C43. The results should be 600 for all formula   results.

2

23

The   next column is designed to calculate the interest amount per payment.
 

  In cell D8, insert the IPMT function using the periodic rate, the current   payment number in the first column, the number of payments, and loan. Use   relative and mixed references correctly. Make sure the result is a positive   value. Copy the function to the range D9:D43.

3

24

Column E is to display the portion of the payment   that goes toward paying down the principal.
 

  In cell E8, insert the PPMT function using the same arguments that you used   for the IMPT function. Copy the function to the range E9:E43.

3

25

You are   now ready to calculate the ending balance after each payment. After you   complete this step, the amortization table should display complete results.
 

  In cell F8, enter a formula that subtracts the principal payment from the   beginning balance. Copy the formula to the range F9:F43.

2

26

You are ready to format the amortization table.
 

  Format the range B8:F8 with Accounting Number Format. Format the range B9:F43   with Comma Style.

2

27

Format   the range C44:E44 with the Total cell style.

1

28

You decide to include a column to show the   cumulative interest after each payment.
 

  In cell H8, insert the CUMIPMT function using the periodic rate, number of payments, loan, first payment   number as start period, first payment number as end period, and 0 as the Type   argument. Use mixed references for all cell references except the end_period   argument, which should be a relative reference. Edit the function to display   a positive result. Copy the function to the range H9:H43.

4

29

Finally,   you want to calculate cumulative principal after each payment.
 

  In cell I8, insert the CUMPRINC function using the same arguments that you   used for the CUMIPMT function. Copy the function to the range I9:I43.

3

30

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

0

Total   Points

100

You may refer to external sources as well and site them.

Prompt

Design and build a simple CPU on Logisim and write programs that can run on it. you can download Logisim by following this link: http://www.cburch.com/logisim/download.html

Your design will go through four phases:

Phase One

Start by building an 8-bit ALU using Logisim. This ALU can implement 16 instructions on 8-bit operands. We would suggest the following minimum list of instructions:

• Arithmetic addition
• Increment
• Decrement
• Comparison (with 3 outputs: one for equals, one for less than and one for greater than)
• Logic bitwise Not
• Logic bitwise And
• Logic bitwise Or
• Register right logic shift
• Register left logic shift

In addition to these nine instructions, please suggest five more instructions that the ALU can implement for a total of 14 instructions (we are reserving 2 instructions for branching). Justify the importance of the five instructions you added in a Word doc to submitted as part of this assignment. Label these instructions as ‘Phase One.’

After you’ve suggested and justified your five suggested instructions, please build at least the nine above-mentioned operations as blocks in Logisim.

Phase Two

In phase two of the project, you are required to design the instruction set of the ALU/CPU as follows:

• Create the opcode table for the ALU by giving a binary code and a name for each instruction you built in Logisim in phase one.
• Decide how many operands you want your instructions to handle and justify your choice. We suggest either one operand with accumulator or two operands with the result stored in one of the input registers.
• In Logisim, add a multiplexer to the circuit you built in phase one that chooses one of the available operations. The simplest way to create this part of the CPU is to connect the outputs of the multiplexer to the inputs of AND arrays connected to the output of the operation blocks.

Phase Three

In phase three, you are required to use Logisim to implement the control unit for at least the following three operations:

• addition
• logic bitwise AND
• right logic shift

In order to finish this phase, you need to add operand registers according to the decision you took for the number of operands in phase two and, if needed, a flag register.

Please record your answer to phase three in the same Word doc and label it ‘Phase Three.’

Phase Four

In order to be able to write assembly language for the CPU we need to add to instructions (without implementation):

• branch to an address (name it JMP)
• conditional branch to an address (name it CJMP and suppose that the jump takes place if the comparison operation result is ‘equals’)

Now, write the following programs using the assembly language you designed in the previous phases of the project as well as these two branching additional instructions:

• Write a program that adds two operands.
• Write a program that adds operands until the new value to be added is 0. You do not need to implement the input operations to modify the contents of the registers. Just assume that by the end of each iteration, the register content is modified.
• Write a program that increments by 2 the content of a register 10 times.
• Write a program that shifts the content of a register until the least significant bit is 0. Think of a way to stop shifting if the content of the register is 11111111 and add it to your program.

Please record your programs in the same Word doc and label them under the section ‘Phase Four.’