3.1.2 Database Design
MySQL has been used for managing customer information of the system
which is an open source database management system. The Database Design
of the System is shown in figure 2. It consists of three entities: user,
customer and note. User is for storing user’s information, note for
holding the user’s notes such as monthly expenses and the customers’
information that need to be updated for the next month and customer for
storing customer information including name, number of amperes, date,
money per ampere and board. Boards are numbered for sorting purposes. A
board is a group of customers sorted according to the quarters in which
they live.