Overview You are a senior software developer on a team of software developers who are responsible for a large banking web application. Your manager has recently learned about the best practice of creating unit tests for software and wants to see a full example of how it works. Another developer on the team started creating a unit test for the std::vector class, and he managed to get the TextFixture and a few tests completed before his vacation started. Your manager is impatient and has asked you to complete the task. He wants to see a number of tests, including positive and negative tests. Key Concepts Positive tests prove that functionality works when tested. For example, Test(1+1) = 2. Negative tests prove that an error or exception happens when provided bad data. For example, Test(5/0) => Divide By Zero. The following are some essential notes: The source code has been commented using TODO to explain the detailed rules you must follow. You are provided the situation to create 13 unit tests, of which 11 are defined for you and 2 you will need to define. You only need a minimum of 2 negative tests, but can do more. Test names should reflect the purpose of a test. For example, to test that a number is positive, the test name would be something like EnsureNumberIsPositive. Do not confuse the C++ assert / static_assert with the Google Test ASSERT and EXCEPT. When should you use the EXPECT_xxx or ASSERT_xxx macros? Use ASSERT when failure should terminate processing, such as the reason for the test case. Use EXPECT when failure should notify, but processing should continue. There are multiple ways to validate the test results, but each test must explicitly prove the defined condition of the test. Do not forget that you can leverage capabilities provided by the standard C++ library to help you achieve success. You will learn to do the following: Name unit tests correctly Compile and run a Google unit test fixture Extend Google unit test fixture with a number of positive and negative tests Prove the test results Prompt Test the existing source code in the test.cpp file using the Google unit testing framework. Include a brief written summary of the process you used, the issues you found, and how you managed the issues. Specifically, address the following in a static testing summary: Unit Test Names: Define all unit test names to appropriately reflect the test condition. Unit Testing: Successfully implement the 13 unit tests, as part of the Google Test fixture; run Google Test ASSERT and EXPECT functionality to prove the tests. Each test you run must explicitly prove the defined condition of the test. Negative Unit Tests: Complete at least 2 of the unit tests as negative tests that demonstrate capturing the appropriate unit test result based on an expected negative result of the test code. C/C++ Program Functionality and Best Practices: Demonstrate industry standard best practices, including in-line comments and appropriate naming conventions to enhance readability of code. Develop functional C/C++ code that illustrates a software design pattern approach. Process Summary: Provide a summary of the debugging that is thorough and systematic, including specific types of bugs, and that accurately describes the corrections.

Hi, InstructionsIn this lab, you will learn how to write Advanced queries using Aggregate Functions and Table Joins. You will write 10 SQL SELECT statements to query the STUDENT schema. Your Select Statements should run error-free and should be valid.Submit two separate files: one plain text file (.txt or .sql file) with your SELECT statements only; and the other document (doc/docx/pdf) include both your SELECT statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document.Q1. List all courses that have "Intro to Information Systems" as prerequisite. (HINT: use a subquery)Q2. List all courses with above average cost. Display course description, cost, and the average cost of all courses. (HINT: use a subquery)Q3. For each zip that has at least one instructor, list the total number of instructors in that zipcode.Q4. For each city in the state of CT, list the total number of students live in that city. Display city, state, number of students in descending order.-- AGGREGATION OF FULL RESULT SETQ5. Find the minimum, maximum, and average grade of final exams in sections taught by Todd Smythe.Q6: For all students who took "Intro to Information Systems", calculate the highest, lowest, and average midterm exam grade for each section. Display Section No and calculation results.-- TABLE JOIN WITH HAVING-CLAUSEQ7. List the instructor id and name of the instructors that teach fewer than 10 sections regardless of student enrollment.Q8. Show which city has the most students. Display city and state, and number of students.Q9: List all zipcodes where at least three students AND at least four instructor reside. Show zip, state and city.Q10: List all cities that have 10 or more students and instructor combined. Show city, state, number of student residents, number of instructor residents, and total student/instructor residents in that city. Sort by total in descending order. Learning Resourceshttps://www.w3schools.com/sql/sql_join.asphttps://docs.oracle.com/database/121/SQLRF/functions.htm#SQLRF006