You are required to design a semi$-$automated system, that manages the visitors to a residential complex. It is required to ensure that all logs of

any type of visitors are maintained and reports created regularly. Provide an HLD for the design which contains $($a$)$ Choice of architectural

patterns $($b$)$ Explanation in brief the reasons for the choice of the patterns $($c$)$ Depict with a diagram the dynamic use case for a visitor

registration, entry and exit.

No need to answer the above question but based on the above question answer the below question :$-$

In the same SQL engine project in the previous question, your team has developed and deployed it within the ERP application. After testing and

use for some period, it is decided to try to improve the efficiency of the SQL engine by caching the outcomes of previous queries and reusing

them partially for new queries whenever relevant. Which refactorings are useful here, and how?