You designed an OLAP database for Home Warrany Corporation. Based on that design, submit the following two SQL statements.Use the CUBE extension to show the sum of costs aggregated by all permutations of appliance serial,  employee id, customer id, and year.Use the GROUPING SETS extension to show the same data.Home Warranty Corporation DATABASE.pdf 

Write a 2- to 3-page paper describing the pros and cons of out-of-band network management as opposed to in-band network management. Include the following in your paper: Examples of protocols or software to perform both out-of-band and in-band network management and a discussion of their effect on network traffic The effect of enterprise systems and how they may relate to, influence, or be influenced by existing business intelligence and decision support systems Format your paper consistent with APA guidelines.

Assignment 3: Creating a Test PlanDue Week 7 and worth 60 pointsThis assignment consists of two (2) sections: a test plan and a PowerPoint presentation. You must submit the two (2) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for.  Section 1: Test PlanIn the previous assignments, you were tasked to develop a Web-based student registration system. Senior management was pleased with your proposal and gave you the green light to start with the project. You have determined the system requirements and your team is now in the middle of developing the final product. To ensure that the software is written according to the requirement specification, you are now focusing on the testing plan for this project.Write a five to six (5-6) page paper in which you:Describe three (3) types of tests that will be needed to test this software system.Describe the strategy you would use for each type of test.Outline the test cases in a test plan for each type of test.    Section 1 of this assignment must follow these formatting requirements:Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.