Dear CaveatEmptor,
The current billing database model is storing and issue on individual bias. In which ways I change the database schema, so that a user can receive a monthly statement rather than receive seperated transaction billing.
At a specified day of each month, adjustment is done on the statement and store for a record.
I have no good idea how to work out the database model. I have difficulties on working out a model which is fitting the easy searching, updating and data integrity criteria.
Please be kindly letting me know the solution.
Thank you very much.
Regards,
Chrono
|