Description:
This is a simple Electricity Bill Payment System designed for the Electricity bill corporation to provide an easy and efficient way for consumers to view and pay their monthly bills. The system allows consumers to view their bills, pay their bills, and view their transaction history. It also allows the administrator to view all the consumers, bills, paid and pending bills, and to delete a consumer.
Database:
The system is designed using a MySQL database. The database has two tables, a Consumer table, and a Bill table. The Consumer table stores information about the consumers, and the Bill table stores information about the bills generated for each consumer. The two tables are related, where a consumer can pay many bills, and a bill is related to one consumer.
The Consumer table has the following columns:
Consumer_id (Primary key)first_name
last_name
username (Unique, not null)
password (Not null)
address
mobile_number
is_active
The Bill table has the following columns:
bill_id (Primary key)consumer_id (Foreign key)
amount
bill_from
bill_to
The Transaction table has the following columns:
transaction_id (Primary key)consumer_id (Foreign key)
amount
payment_date