Question

A new technology company would like to build a database to implement mobile money in Jamaica. The company would like to store information on clients who can be categorized as senders or receivers. Clients have a TRN, name, Date of Existence, email, all mobile numbers, address and customer type. A client can be a sender and receiver at the same time. The company would like to know which Client referred another client if a referral occurred. A sender may have a verification pin and pin expiry date where as receivers will have External Id Number (not unique), ID expiry Date, ID Issuing Country and Id Type.

Each Sender can transfer money to a receiver by creating a transaction identified by a system-generated transaction Id. The company would also like to store the transaction amount and date. A set of related transaction can be flagged under an investigation where the investigation will have a reference number, date it started and date ended and the purpose of the investigation. One investigation can contain several transactions as well as one transaction can be linked to several investigations. When each investigation takes place the company would like to assign an auditor to the transaction for that particular investigation. Auditors have an ID, name, Dob, Gender and salary.
Required
a) You are required to model the above scenario in a conceptual diagram. Your diagram should show:
i) cardinalities
ii) entity participation
iii) state any assumptions that do not conflict with the scenario. Further assumptions should be used to clarify only ambiguous statements.

Answer 1

A new technology company planning to implement mobile money in Jamaica needs to build a database to store client information. The database should have fields for TRN, name, Date of Existence, email, mobile numbers, address, and customer type. Clients can be categorized as senders or receivers, and a client can be both. The database should also track referrals and have tables for clients, referrals, and entity participation.

Step-by-step explanation:

A new technology company planning to implement mobile money in Jamaica would need to build a database to store client information. The database should have fields for TRN (Taxpayer Registration Number), name, Date of Existence, email, all mobile numbers, address, and customer type. Clients can be categorized as senders or receivers, and a client can be both a sender and a receiver. If a referral occurs, the database should track which client referred another client. Additionally, senders may have a verification pin and pin expiry date, while receivers will have an External Id Number, ID expiry Date, ID Issuing Country, and ID Type.

To ensure proper entity participation in the database, it should have tables for Clients, Referrals (to track referrals between clients), and Entity Participation (to link clients to their respective roles as senders or receivers).

Assumptions that do not conflict with the scenario include:

• All clients have a valid TRN, name, email, and mobile numbers.
• A client can be both a sender and a receiver at the same time.
• Verification pins for senders and external ID numbers for receivers are optional fields.
• The sender's pin expiry date and the receiver's ID expiry date are optional fields.
• The client's address is a single address field and not divided into separate fields like street, city, and postal code.