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.