Assessment description This assessment tests your knowledge and skills in Database and software testing. For the first part you will be assessed on database design in writing queries using SQL and producing a suitable view according to certain business rules. For the second part you will produce a minimum set of tests to assess different problems according to certain business rules. The assessment requires you to integrate and synthesise what you have learnt so far in this unit, in order to design and create a proper working solution, and to perform a basic SQL query and a basic software testing task. This assessment will provide evidence towards the following unit learning outcomes: ULO$4$: Apply the fundamentals of database management systems and relational databases. Assessment instructions Part $1$: Databases Step $1$: Use the file DreamHome.db to test your queries. DreamHome.dbDownload DreamHome.db An overview of the database is also available: Assessment Databases: Overview of DreamHome $($PDF$)$Download Assessment Databases: Overview of DreamHome $($PDF$)$ Step $2$: Answer the following questions using SQL to produce the view. Only the SQL query will attract marks, not the view. Note: You must include at the end of your query: the degree and cardinality of the resulting view, primary and foreign keys, one sentence explaining the content of the first tuple based on the attributes queried. Question set: Find the total number of Managers and the sum of their salaries. Find the minimum, maximum, and average staff salary. For each branch office with more than one member of staff, find the number of staff working in each branch and the sum of their salaries. Construct a list of all cities where there is either a branch office or a property. Construct a list of all cities where there is both a branch office and a property. Part $2$: Software testing Step $1$: Use the HTML files to test your queries. Make sure you use the correct $.$html file to answer each question. Competency.htmlDownload Competency.html Parking.htmlDownload Parking.html Step $2$: You are asked to work out the required tests needed. The description of the problem, business rules, variables and variable types $($including a test example$)$ are included below for each HTML file. Step $3$: Edit the HTML file to include the test cases as described during the lectures and tutorials. All pieces of software to test are designed such that they do not need more than $10$ tests. That is$,$ you only have up to $10$ tests available to assess all boundaries and partitions. Step $4$: Be sure to save your answers and submit your HTML file as described in the Assessment formatting guidelines. Note: No more than $10$ tests can be used. That is$,$ all tests above the $10$th won$$t be considered for marking purposes. Competency You are asked to work out the required tests needed to assess the performance of a function called CompetencySatisfied using the file $$Competency$.$html$.$ Complete: List all inputs. All boundaries are tested. All partitions are tested. Proper descriptions are given for every test. Parking You are asked to work out the required tests needed to assess the performance of a function called Chris, Kim and Pat using the file $$Parking$.$html$.$ Complete: List all inputs. All boundaries are tested. All partitions are tested. Proper descriptions are given for every test.