Dear ALL,

I have studied CaveatEmptor and wants to have some changes on it.

The current CaveatEmptor billing method is by storing asingle bill 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