Please provide the exact answer with detailed explanation, its all about derived data concept.

The company have said they would like to extend the database to include costing information for repair work. Data should be kept on the cost of parts and the rate of pay of staff. There should be a way of calculating how much work costs for particular properties, the portfolio they belong to and their owners. You should include an outline of how you would derive this data using SQL/NoSQL and specify the method of implementing it. [13 Marks]

Below is the scenario:

Scenario Clinton Letting and Management is a property management company based in London, United Kingdom. They manage properties for owners. An owner will have one or more portfolios of properties, which will consist of one or more properties. Properties are defined as being of a particular type such as residential house, residential flat or commercial property. A particular property will be rented by a tenant. The terms of that rental are defined as a tenancy. Tenant are defined by type ('Private', 'Business', 'Government', 'Other'). As well as managing the tenancies of properties Clinton Letting and Management maintain the property by carrying out repairs when they are needed. A property repair will involve one or more members of staff and can involve one or more parts. The system should be capable of storing all the information needed for Clinton Letting and Management to carry out their business. Several additional requirements are outlined as in Task 2 below, including data entry and queries. Please state any assumptions you have made about the scenario. Please Note: The data shown in the assignment is not necessarily normalised, and that it the candidate's task to organise the data in the most optimal way possible. For example, the paper records shown below will not necessarily map directly to database tables. The candidate is expected to use these tables as a starting point for their own normalisation and optimisation of the Clinton Letting and Management. Please note also that all SQL/NoSQL scripts should be shown along with their results