TELEPHONE BILLING SYSTEM
A Mini Project
Submitted by
SUHAS BONDAGE (Exam Seat No. XXXXXXX)
ADITYA CHIDREWAR (Exam Seat [Link])
DNYANESHWAR KHUNE (Exam Seat No. XXXXXXX)
THIRD YEAR COMPUTER ENGINEERING
Department of Computer Engineering
International Institute of Information Technology
Hinjawadi, Pune – 411057
SEMESTER I (AY 2025-26)
1
TABLE OF CONTENTS
TITLE PAGE NO.
1. ABSTARCT 1
2. INTRODCUTION
2.1 SCOPE
2.2 REQUIRMENT ANALYSIS
2.3 SOFTWARE AND HARDWARE DETAILS
2.4 LIBRARIES / PACKAGES USED
3. DATABASE DESIGN
3.1 DATA MODELING (E-R DIAGRAMS)
4. GRAPHICAL USER INTERFACE (Screenshots of UI)
5. CONCLUSION
2
ABSTRACT:
The Telephone Billing System (Web Version) is a full-stack web application designed to
automate the management of telephone call billing records. It integrates a Java-based backend
(WebServer) with a frontend built using HTML, CSS, and JavaScript, and uses MySQL as the
database. The system allows users to add, display, and delete call records, as well as calculate the
total billing amount automatically. It provides a clean, responsive interface accessible via a web
browser. This project demonstrates how web technologies and Java backend can work together to
create efficient, real-time billing systems.
INTRODUCTION:
The Telephone Billing System aims to simplify and digitize telephone billing operations by
providing a user-friendly, browser-accessible solution. Users can interact with the frontend built
using HTML/CSS/JavaScript, while the backend, developed in Java, handles server-side logic and
database communication through MySQL. This system replaces manual data entry and computation
with automated processes, ensuring efficiency, accuracy, and scalability.
2.1 SCOPE
- Provide an interactive web interface for managing call billing records.
-Store, retrieve, and manage call data in a MySQL database.
-Compute call charges based on duration and rate per minute.
-Dynamically calculate and display the total billing amount.
-Enable adding, deleting, and refreshing call records from the web interface.
-Allow scalability for multi-user and future integrations.
3
2.2 REQUIREMENT ANALYSIS
Functional Requirements:
1. Add, display, and delete call records.
2. Calculate call amount dynamically.
3. Fetch and show total billing.
4. Handle backend communication via HTTP requests.
Non-Functional Requirements:
1. Responsive and mobile-friendly interface.
2. Secure database access.
3. Scalable architecture.
4. Modular and maintainable code.
2.3 SOFTWARE AND HARDWARE DETAILS
Software Requirements:
- Frontend: HTML, CSS, JavaScript
- Backend: Java WebServer
- Database: MySQL
- Connector: MySQL JDBC Driver
- Tools: VS Code, IntelliJ IDEA, MySQL Workbench
Hardware Requirements:
- Processor: Intel i3 or higher
- RAM: Minimum 4 GB
- Storage: Minimum 200 MB
- Display: 1024x768 resolution or higher
2.4 LIBRARIES / PACKAGES USED
Frontend:
- HTMLfor structure
- CSS for design
- JavaScript for dynamic actions
4
Backend:
- [Link], [Link] for HTTP handling
- [Link] for database access
- mysql-connector-j for DB connection
- [Link] for utility
- [Link] for routing
- [Link] for data model
Database:
- MySQL
- telephone_billing.sql for schema setup
3. DATABASE DESIGN
The database consists of one main table: call_records. It stores details of each telephone call and its
billing information.
Entities and Attributes:
-id (Primary Key, INT, AUTO_INCREMENT)
-caller (VARCHAR)
-receiver (VARCHAR)
-call_datetime (DATETIME)
-duration_minutes (INT)
-rate_per_min (DOUBLE)
-amount (DOUBLE)
5
E-R DIAGRAM:
4. GRAPHICAL USER INTERFACE
Frontend Files:
[Link] → Defines the structure of the page (form + table).
[Link] → Styles the layout, gradient background, cards, and buttons.
[Link] → Handles event listeners for Add, Delete, and Refresh actions.
6
UI Description:
The user interface consists of two main sections:
1. Add Call Form (Left Side / Top Section)
o Input fields: Caller, Receiver, DateTime, Duration, Rate
o Buttons: “Add Record”, “Refresh”
o Submits data via JavaScript to Java backend through HTTP POST request.
2. Call Records Table (Right Side / Bottom Section)
o Displays fetched data from MySQL
o Columns: ID, Caller, Receiver, DateTime, Duration, Rate, Amount
o Includes Delete option for each record
o Total billing amount is displayed at the top-right corner.
SCREENSHOT :
7
8
5. CONCLUSION
The Web-Based Telephone Billing System successfully integrates frontend web technologies with a
Java backend and MySQL database to automate call billing management.
It provides an intuitive interface for adding and managing call records and calculates the total billing
dynamically.
This system demonstrates:
Full-stack web development using Java + MySQL + Web UI,
Seamless communication between client and server via HTTP,
Real-time data handling and calculation.
Future Enhancements:
User authentication (login system)
Monthly/Yearly billing report generation (PDF/Excel)
REST API integration
Hosting on a cloud platform for multi-user access