Project 4 Draft: Pattern SearchIntroductionYour task for this project is to use regular expressions to discover and modify information from the provided test.The project is broken into two sections:Determine the number of non alpha numeric characters in the lorem_ipsum string.Replace all instances of dash (-) or a colon (:) with a space in the words ‘sit’ and ‘amet’.Find and print the number of non-alphanumeric characters.Find and print the number of non-alphanumeric characters.The first thing to do when doing a pattern search is to import the module re which provides full support for regular expressions in Python. This has already been provided in the code to the left.Provided for you on the left is the lorem_ipsum string. lorem_ipsum is the string you will be using to change as you go through the programming activities in this course unit.Find all of the instances of non alphanumeric characters in the string assigned to lorem_ipsum.Use the ^ and [] regular expression operator along with the findall() regular expression function.Assign the outcome to a variable named results.Output to the console, the number of non-alphanumeric characters. Hint: use the len function.Hint: use the len function.Output144Find and print the number of 'sit' and 'amet' separated with punctuation marksUsing the re.findall() function, get all of the instances of 'sit-amet' or 'sit:amet' characters in the string assigned to lorem_ipsum.Assign the outcome to a variable named occurrences_sit_ametOutput to the console, the number of sit-amet or sit:amet occurrences.Hint: use the len function.Output3Replace 'sit' and 'amet' words separated with punctuation marks with 'sit amet'Replace sit:amet and sit-amet with sit amet using the re.sub() function.Assign the outcome to a variable named replace_resultsFind and print all the instances of 'sit amet'Using the re.findall() function, get all of the instances of 'sit amet'in the string assigned to replace_results.Assign the outcome to a variable named occurrence_sit_amet.Output to the console, the number of sit amet occurrences.Hint: use the len function.Output3import re#Paragraph provided for search and replacelorem_ipsum = '''Lorem ipsum dolor sit-amet, consectetur adipiscing elit. Phasellus iaculis velit ac nunc interdum tempor. Ut volutpat elit metus, vel auctor enim commodo at. Nunc quis quam non ligula ultricies luctus porta id justo. Quisque dapibus est ut sagittis bibendum. Mauris ullamcorper pellentesque porttitor. Ut sit:amet ex nec dolor gravida porttitor. Proin at justo finibus justo vestibulum congue. Suspendisse et ipsum et ipsum eleifend dapibus a fermentum lacus. Vivamus porta nunc eu nisl sagittis, quis vulputate metus dignissim. Integer non fermentum nisl, id vestibulum elit. Sed euismod vestibulum purus ut porttitor. Integer sit-amet mollis neque. Donec sed lacinia diam, ac finibus lectus. Mauris tempor ipsum nisl, vitae posuere est lacinia nec. Nam eget euismod odio.'''#Place all the code from the previous steps hereLastly, a small assignment reflecting on the project:Reflection - Applying Your Experience Making mistakes when you learn to write code is common. It is part of learning. What is important is developing the skill of learning how to understand your errors and then fix them (debugging). For this part of your final project, you will respond to the following: a) Reflecting on your experience with this activity, explain the importance of knowing how and when to use a search using literal characters, for sequences and ranges, and for special characters and wildcards. Support your response with examples from the activity of the types of errors and your method for fixing them.

  Understanding Operating Systems (Zero-cost course material) Unit 4 Lab Assignment 4: Processor Management (30 points) In this assignment, you will learn to collect information about and send commands to your OS’s processor manager. For each of the two questions, do the following: 1. Create a document (use Microsoft word or any equivalent tool such as LibreOffice) and name it appropriately to reflect the assignment type, number, and your name.  2. Answer the following questions (if any) in the document you created and justify your answers. To do this, you may need to perform some tasks on your computer, use a snipping or “print screen” tool to take screenshots, and paste the illustrations/pictures into the document. Showing screenshots only does not constitute answering a question. You need to provide both the answer to the question and the screenshots. 3. Save and upload the document to the learning management system (Blackboard). Upload the two documents at once. Do not forget to show visual evidence (screenshots) of the main actions you took to answer the questions. Question 1: Windows Virtual Memory (15 points) The /proc file system is a mechanism provided by Linux for the kernel to report information about the system and processes to users. The /proc file system is nicely documented in the proc man page. You can access this document by running the command man proc on a Linux system. Understand the system-wide proc files such as meminfo and cpuinfo, and per-process files such as status, stat, limits, maps and so on. Now answer the following questions using the /proc filesystem.  1. Run command more /proc/cpuinfo and explain the following terms: processor and cores. [Hint: Use lscpu to verify your definitions.]  2. How many cores does your machine have? 3. How many processors does your machine have? 4. What is the frequency of each processor? 5. How much physical memory does your system have? 6. How much of this memory is free? 7. How many context switches has the system performed since bootup? [Hint: use vmstat] Do not forget to show visual evidence of the main actions you took to answer the questions. Question 2: Linux Virtual Memory (15 points) You may perform the tasks in this question on any Linux system. You may find help in [1]. 1. Install and run the utility htop on your Linux OS using the CLI. Answer the following questions: a. How much swap memory do you have? how much of it is being used by your OS? b. For how long has your system been up? c. How do you kill a process in htop? Kill a random process and see if it will have an effect on your OS. 2. Start the text editing program of your choice (e.g., gedit)  a. What is the PID of the editing process? [hint: Use the psutility (module 4-1) and “| grep”] b. Kill the text editing process. What command did you use? c. Issue the “pstree” command. What is the first process that your OS started? What happens if you kill that process? Do not forget to show visual evidence of the main actions you took to answer the questions. Reference: [1]https://linuxtogether.org/htop-command-explanation...

Note : This assignment much follow all the instruction as per professor Assignment InstructionsCreate the following SQL script (Save as w6_firstname_lastname.sql) .Create a simple Database and do the following1) Create a table using SQL script with 5 fields2)Create insert script(10 inserts)3)Create update script(10 updates)4)Create the following:-a)Selectall recordsb)Selectall records sorted descending , ascendingc)Selectall records with condition (where)d)Count all recordse)Countall record with condition5) Create 3 delete scriptsSubmit your week 6 work in w6_firstname_lastname.txt (Please save the file as a text file of your scripts and upload the text file here for final review.)