$*$Note: $-$ Please Use Microsoft Visio or draw.io$*$

Part I. Conceptual Database Model

Debt collection systems are designed to help organizations process and manage debt collections. The system will usually include features such as a payment portal, automated dunning letters and emails, rules$-$based workflow automation, balance tracking and reporting, and integration with existing business systems. The goal of using a debt collection system is to streamline the process of chasing up overdue payments to reduce manual labor, speed up the payment process, and improve customer relationships.

Given the following business rules, design a conceptual database model as Crow's Foot entity relationship Diagramalong with specifying the attributes, the primary keys and foreign keys when applicable in each entity, and the relationships between entities with the minimal and maximum cardinality at each end. Use Microsoft Visio or draw.io$.$

The debt collection system keeps tracks of debtors and their accounts in collection.

A debtor is identified with first and last name, physical address as street number, city and province, phone number, email address and a salary. A debtor may have a current job held where a job title may be shared by many debtors.

A debtor's account represents a loan and has an opening balance, default date that is the date at which the debtor stopped paying, interest rate, owing balance that is the remaining balance after several payments done, and a status that could take the values closed or active. A loan has a type that could take the values: house, car, rental, etc.

A debtor is associated with one or more accounts in collections. An account may be associated with one or more debtors as co$-$applicants for the loan.

A collection agency is identified with a code and name. A collection agency may chase many debtor's accounts. An account is chased by one and only one collection agency.

A debtor may perform many payment transactions towards an account. An account may receive credit multiple times from many debtors since an account may be assigned with co$-$applications. A payment transaction is identified with a payment number, amount, payment date, credit type.