It would be much better if you share screenshots with Microsoft SQL server management. thank you.

an apartment site management web application manages the accrual and payment process of the residents' bills such as apartment dues, water expenses, and the like. while some of the invoices are accrued to the flat owner, some are accrued to the tenant, if any, to the flat owner. This decision is adjusted through the application with the decision of the site administration. in addition, each invoice has a due date. f the person who is required to pay the invoice pays the invoice after the due date, a daily penalty will be applied at 5% monthly interest for each day of delay.

- according to the explanation above, create the necessary tables and the relationship between them

- according to the person information given as a parameter, write the query as function that shows the instant debt amount on an invoice basis

- write the query as stored procedure that shows the total debt of each flat in the form of alist