1) What is GIS Web? What Tiers comprise GIS Architecture?2)What are the 7 elements of a map?3)What is smart mapping?RequiredMinimum 200 words eachIndividual word files with Individual referencesAPA Format(You could potentially get 30 points for your answers on this Discussion Question,If the answer is substantial, complete and correct. The answers have to be original, interesting and up-to-the-point. Your personal thoughts, critical thinking and analytical approach will be valued the most!)ReferencesGetting to know Web GIS, Pinde Fu, 2016, ESRI Press. (ISBN: 978-1589484634) Understanding GIS, fourth edition, David Smith, Nathan Strout, Christian Harder, Steven Moore, Tim Ormsby, Thomas Balstrom, 2018, ESRI PressAdditional Reading Materials:It is expected that students will make extensive use of the following journals:International Journal of Geographical Information Systems;Geospatial Solutions;Geo-World;ESRI Press: Arc User & Arc News

Write a SELECT statement that returns the product_name and list_price columns from the Products table.Return one row for each product that has the same list price as another product.Hint: Use a self-join to check that the product_id columns aren’t equal but the list_price columns are equal.Sort the result set by the product_name column. Submit a screenshot. Write a SELECT statement that returns these two columns:category_name        The category_name column from the Categories tableproduct_id               The product_id column from the Products tableReturn one row for each category that has never been used. Hint: Use an outer join and only return rows where the product_id column contains a null value. Submit a screenshot. Write an INSERT statement that adds this row to the Customers table:email_address:         rick@raven.compassword:                (empty string)first_name:                Ricklast_name:                 RavenUse a column list for this statement. Submit a screenshot. Write a SELECT statement that answers this question: Which customers have ordered more than one product? Return these columns:The email_address column from the Customers tableThe count of distinct products from the customer’s ordersSort the result set in ascending sequence by the email_address column. Submit a screenshot. Write a SELECT statement that answers this question: What is the total quantity purchased for each product within each category? Return these columnsThe category_name column from the category tableThe product_name column from the products tableThe total quantity purchased for each product with orders in the Order_Items tableUse the WITH ROLLUP operator to include rows that give a summary for each category name as well as a row that gives the grand total.Use the IF and GROUPING functions to replace null values in the category_name and product_name columns with literal values if they’re for summary rows. Submit a screenshot. Write and execute a script that creates a user with a username using your firstname initial and lastname and password of your choosing. This user should be able to connect to MySQL from any computer.This user should have SELECT, INSERT, UPDATE, and DELETE privileges for the Customers, Addresses, Orders, and Order_Items tables of the My Guitar Shop database.However, this user should only have SELECT privileges for the Products and Categories tables. Also, this user should not have the right to grant privileges to other users.Check the privileges for the user by using the SHOW GRANTS statement. Submit a screenshot. Write a SELECT statement that returns these column names and data from the Products table:product_name The product_name columnlist_price The list_price columndiscount_percent The discount_percent columndiscount_amount A column that’s calculated from the previous two columnsdiscount_price A column that’s calculated from the previous three columnsRound the discount_amount and discount_price columns to two decimal places. Sort the result set by the discount_price column in descending sequence. Use the LIMIT clause so the result set contains only the first five rows. Submit a screenshot. Write a SELECT statement that returns these column names and data from the Order_Items table:item_id The item_id columnitem_price The item_price columndiscount_amount The discount_amount columnquantity The quantity columnprice_total A column that’s calculated by multiplying the item price by the quantitydiscount_total A column that’s calculated by multiplying the discount amount by the quantityitem_total A column that’s calculated by subtracting the discount amount from the item price and then multiplying by the quantityOnly return rows where the item_total is greater than 500. Sort the result set by the item_total column in descending sequence. Submit a screenshot. Write a SELECT statement that answers this question: Which customers have ordered more than one product? Return these columns:The email_address column from the Customers tableThe count of distinct products from the customer’s ordersSort the result set in ascending sequence by the email_address column. Submit a screenshot. 

InstructionsThe first deliverable of the Penetration Test Proposal is the rules of engagement (ROE) document, a formal document that outlines the objectives, scope, methodology, and overall test plan agreed upon by the penetration testers and client system administrators. Penetration testing can cause complications such as network traffic congestion, system downtime, and may cause the same vulnerabilities and compromises it was designed to prevent. Due to the potential consequences of penetration testing, it is vital to agree upon a comprehensive ROE before testing.For your ROE deliverable, consider the following:How will you identify Haverbrook Investment Group's network characteristics, expectations, constraints, critical systems, and other relevant information?What are your preliminary engagement activities with regard to scheduling, scope, and key stakeholders?What will you use to establish a binding agreement between Centralia Security Lab and Haverbrook Investment Group?How will you determine the services, targets, expectations, and other logistics that will be covered during the Rules of Engagement section?How will you explain to Haverbrook that the tools and techniques to be used in the penetration test will not corrupt data, violate privacy, and are in compliance with industry standards and any applicable laws and regulations?Use the attached pdf documents for information. Use the Microsoft Word document as a template for how the assignment should be drafted.