Exam
Pitok Grocery is the most popular wholesale grocery store in Cagayan de Oro City. Aside from cash payment, they also let customers to purchase through credit.
To apply for a credit account, a customer needs to provide his full name, address, contact number, birth date, source of income and monthly income. After a customer is approved for a credit account, he will be assigned to a group based on the terms provided by the store. As of the moment, there are four groups namely Bi-monthly, Monthly, 45 days and 60 Days and they have the option to add more groups when necessary
When a customer makes a purchase, he is going to be issued with a sales invoice. The invoice contains the total amount of the items he purchased for that transaction. That customer is then billed according to what group he belong.
When a customer makes a payment, he will be given with an official receipt as a proof that he already made a payment against the invoice he was billed for. The clerk is going to record the payment by writing the customer's name, amount paid and the date he made the payment.
If a customer, for whatever reason, is not able to pay on or before the due date, an additional amount will be debited/added to his account and any extra payment will be credited.
You are tasked to design the database (ERD) for the Accounts Receivables system for Pitok Grocery.
To apply for a credit account, a customer needs to provide his full name, address, contact number, birth date, source of income and monthly income. After a customer is approved for a credit account, he will be assigned to a group based on the terms provided by the store. As of the moment, there are four groups namely Bi-monthly, Monthly, 45 days and 60 Days and they have the option to add more groups when necessary
When a customer makes a purchase, he is going to be issued with a sales invoice. The invoice contains the total amount of the items he purchased for that transaction. That customer is then billed according to what group he belong.
When a customer makes a payment, he will be given with an official receipt as a proof that he already made a payment against the invoice he was billed for. The clerk is going to record the payment by writing the customer's name, amount paid and the date he made the payment.
If a customer, for whatever reason, is not able to pay on or before the due date, an additional amount will be debited/added to his account and any extra payment will be credited.
You are tasked to design the database (ERD) for the Accounts Receivables system for Pitok Grocery.
Comments
Post a Comment