A database designer or other IT professional, may want to put the customer balance as a field in the Sales Receipts table to speed up retrieval.

Question

Quizplus · Accepted Answer

The customer balance is not a relevant field in the Sales Receipts table. It would be more appropriate to have a separate table for customer accounts that includes the balance field and have a foreign key linking it to the Sales Receipts table if necessary. Including the customer balance in the Sales Receipts table could possibly slow down retrieval as it would add unnecessary data to the table.

A Database Designer or Other IT Professional, May Want to Put