INDEX

MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION

NAVJEEVAN EDUCATION SOCIETYPOLYTECHNIC

MICRO PROJECT

Academic year: 2023-24

TITLE OF MICRO PROJECT

BILLING MANAGEMENT
Program : Information Technology.
Program code: SYIF
Course: DBMS
Course code: 313302
1
 MAHARASHTRA STATE BOARD OF
TECHNICAL EDUCATION
Certificate
This is to certify that 1. Nikita Shinde
2. Kirti Dubey
3. Sanika Patil
of 3nd Semester of Diploma in Information Technology of Institute,
Navjeevan Polytechnic(Code: 0144) has completed the Micro Project
satisfactorily in Subject: DBMS for the academic year 2023- 2024 as
prescribed in the curriculum.
Place: Bhandup. Enrollment no: 1. 23111050357
2. 23111050358
3. 23111050359
Date:-………………
Subject Teacher Head of the Department Principal

2
 GROUP DETAILS

SR. NO Name of Group Roll no Enrollment No Seat no

Members
1 Nikita Shinde 443 23111050357
2 Kirti Dubey 444 23111050358

3 Sanika Patil 445 23111050359

Helped and guided by:

3
 Resources Required: -
SR. Name Of Specifications Qty
NO Resources/material
1 Computer System Operating System: Windows 11 or 1
higher.
RAM. Processor: Core i3.
HDD: 500GB or Larger.
2 Software MYSql

4
 Topic: BILLING MANAGEMENT
Academic Year: 2023-2024 Name of Faculty:

Program Code: SYIF.

Course & Course Code: Database Management System (313302).
Enrollment no: - 23111050357,23111050358,23111050359.
Semester: III
Name of the candidates: Nikita Shinde, Kirti Dubey, Sanika Patil

Sr.NO Week Activity of Performed Planned start Planned Name of

Date Finish Date Responsible
Team member
1. 1st Discussion and All Team
finalization of topic Members

2. 2nd Preparation and All Team

Members
submission of Abstract
3. Collection of data All Team
Members
4. implementation All Team
Members

5. Check, validation and All Team

execution of code Members

6. Compilation of report All Team

and presentation Members

7. Actual Presentation & All Team

Final submission of Members
Micro
Project

5
Brief description: -

A Billing Management System is software designed to streamline and

automate the process of invoicing, payment collection, and financial tracking
for businesses. It enhances accuracy, reduces manual errors, and improves
efficiency in managing customer billing and financial records.

Aims of Microproject: -

The aim of the microproject for a Billing Management System could

include:
• Automate Invoicing: Develop a system to generate and manage invoices
automatically, reducing manual effort.
• Improve Accuracy: Ensure precise calculation of billing amounts,
minimizing human errors.
• Streamline Payments: Facilitate seamless payment collection and
processing from customers.
• Enhance Record-Keeping:Maintain accurate and organized financial
records for easy access and auditing.
• Optimize Customer Management: Track and manage customer billing
information efficiently.
• Increase Efficiency: Reduce the time and resources needed to manage
billing processes.
• Provide Reporting:Generate financial reports for better business insights
and decision-making.

Course Outcome Integrated: -

1.Design Normalized database on given data.
2.Create and manage database using SQL command.
3.Able to write PL/SOL code for given database.

6
4.Apply triggers to database also create procedure and function according to
condition
5 .Apply security and confidentiality on given database.

Key Components and Database Design :

1. Categories Table
Stores information about different product categories, enabling the
organization of products into logical groups.
• CategoryID: Unique identifier for each category (Primary Key)
• CategoryName: Name of the category

2. Products Table
Contains detailed information about the products available in the
store.
• ProductID: Unique identifier for each product (Primary Key)
• ProductName: Name of the product
• CategoryID: Foreign key linking to the Categories table
• Price: Price of the product
• Stock: Quantity available in inventory

3. Customers Table
Maintains information about the customers, facilitating customer
relationship management.
• CustomerID: Unique identifier for each customer (Primary Key)

7
 • CustomerName: Name of the customer
• ContactNumber: Customer's contact number
• Email: Customer's email address
• Address: Customer's residential address
4. Employees Table
Stores data about the employees, including their roles and
compensation.
• EmployeeID: Unique identifier for each employee (Primary Key)
• EmployeeName: Name of the employee
• Position: Job title or role
• Salary: Employee's salary

5. Orders Table
Tracks orders placed by customers, including relevant details such as
order date and total amount.
• OrderID: Unique identifier for each order (Primary Key)
• CustomerID: Foreign key linking to the Customers table
• OrderDate: Date when the order was placed
• TotalAmount: Total value of the order

6. OrderDetails Table
Records specific details about each product included in an order.
• OrderDetailID: Unique identifier for each order detail (Primary
Key)
• OrderID: Foreign key linking to the Orders table
8
 • ProductID: Foreign key linking to the Products table
• Quantity: Quantity of the product ordered
• UnitPrice: Price per unit of the product

Database Schema Diagram :

Project Objectives

9
 1. Inventory Management: Track product details, stock levels, and
categories.
2. Sales Tracking: Record transactions, manage orders, and
generate sales data.
3. Customer Management: Maintain customer profiles and
purchase histories.
4. Employee Management: Manage employee data, including
roles and salaries.
5. Order Management: Process orders and maintain order details.
6. Reporting and Analytics: Provide insights and reports for
decision-making.

Brief Description of the Project:

A Billing Management System is a comprehensive software

solution designed to automate the invoicing, payment processing,
and financial tracking for businesses. It ensures accurate billing,
reduces errors, and provides efficient management of customer
accounts. The system also offers reporting features, helping
businesses monitor financial performance and streamline their
billing operations.The aim of the Billing Management System
microproject is to develop a streamlined solution for automating
invoicing, payment processing, and financial record-keeping. This
project seeks to enhance accuracy, reduce manual errors, and
improve efficiency in managing customer billing. Additionally, it
aims to provide insightful reporting to support better business
decisions.

10
SQL Implementation
CODE:
CREATE TABLE customers (
Id INT PRIMARY KEY,
Name VARCHAR(255),
Email VARCHAR(255),
Phone VARCHAR(20),
Address TEXT,
City VARCHAR(100),
State VARCHAR(100),
Zip VARCHAR(20),
Country VARCHAR(100)
);

CREATE TABLE items (

Id INT PRIMARY KEY,
Name VARCHAR(255),
Description TEXT,
Price DECIMAL(10, 2),
Tax_rate DECIMAL(5, 2)
);

11
CREATE TABLE invoice_items (
Id INT PRIMARY KEY,
Invoice_id INT,
Item_id INT,
Quantity INT,
Unit_price DECIMAL(10, 2),
Total DECIMAL(10, 2),
FOREIGN KEY (invoice_id) REFERENCES invoices(id),
FOREIGN KEY (item_id) REFERENCES items(id)
);

CREATE TABLE payments (

Id INT PRIMARY KEY,
Invoice_id INT,
Payment_date DATE,
Amount DECIMAL(10, 2),
Payment_method VARCHAR(100),
FOREIGN KEY (invoice_id) REFERENCES invoices(id)
);

CREATE TABLE payment_methods (

Id INT PRIMARY KEY,
12
 Name VARCHAR(100),
Description TEXT
);

CREATE TABLE taxes (

Id INT PRIMARY KEY,
Name VARCHAR(100),
Rate DECIMAL(5, 2)
);

CREATE TABLE users (

Id INT PRIMARY KEY,
Username VARCHAR(100),
Password VARCHAR(255),
Role VARCHAR(50)
);

13
Creating Table:

14
15
16
17
Conclusion
The Billing Management System microproject helps develop
critical skills such as software development, database management,
and financial data analysis. It enhances problem-solving abilities,
understanding of automation processes, and proficiency in creating
user-friendly interfaces. Additionally, it cultivates skills in project
management, teamwork, and delivering efficient, reliable software
solutions for real-world business challenges..

18
 Micro Project Evaluation Sheet
Name of Student: Nikita Shinde
EnrollmentNo. 23111050357
Course: SYIF. Semester: III.

Course Title: Database management system.

Title of Microproject: Billing Management
Course Achieved: - 1. Design Normalized database on given data.
2. Create and manage database using SQL command.

Sr. Characteristics to be Poor (Marks 1-3) Average Good Excellent Sub Total
assessed (Marks 4 -5) (Marks 6-8) (Marks 9-10)
No.

(A). Process and Product Assessment (Convert above total marks out of 6 marks.)

1. Relevance to the Course

2. Literature
Review/information
collection

3. Completion of the target

as per project proposal

4. Analysis of data and

representation

5. Quality of
Prototype/Model

6. Report
Preparation.

(B). Individual Presentation/Viva (Convert above marks Total Marks out of 4.)

7. Presentation

8. Viva

Sr. Characteristics to be assessed Poor (Marks 1-3)

No.

(A). Process and Product Assessment (Convert above total marks out of 6 marks.)

19
 Micro Project Evaluation Sheet
Name of Student: Kirti Dubey

EnrollmentNo. 23111050358.

Course: SYIF. Semester: III.

Course Title: Database management system.

Title of Microproject: Billing Management

Course Achieved: - 1. Design Normalized database on given data.

2. Create and manage database using SQL command.

Sr. Characteristics to be Poor (Marks 1-3) Average Good Excellent Sub Total
assessed (Marks 4 -5) (Marks 6-8) (Marks 9-10)
No.

(A). Process and Product Assessment (Convert above total marks out of 6 marks.)

1. Relevance to the
Course

2. Literature

Review/information
collection

3. Completion of the
target as per project
proposal

4. Analysis of data and

representation

5. Quality of

Prototype/Model

6. Report
Preparation.

(B). Individual Presentation/Viva (Convert above marks Total Marks out of 4.)

7. Presentation

8. Viva

(A) (B)
Process and Product Assessment (6 marks) Individual Presentation Total Marks 10

20
 /Viva (4 marks)

Micro Project Evaluation Sheet

Name of Student: Sanika Patil

EnrollmentNo. 23111050359.

Course: SYIF. Semester: III.

Course Title: Database management system.

Title of Microproject: Billing Management

Course Achieved: - 1. Design Normalized database on given data.

2. Create and manage database using SQL command.

Sr. Characteristics to be Poor (Marks 1-3) Average Good Excellent (Marks Sub Total
assessed (Marks 4 -5) (Marks 6-8) 9-10)
No.

(A). Process and Product Assessment (Convert above total marks out of 6 marks.)

1. Relevance to the
Course

2. Literature
Review/information
collection

3. Completion of the
target as per project
proposal

4. Analysis of data and

representation

5. Quality of
Prototype/Model

6. Report
Preparation.

(B). Individual Presentation/Viva (Convert above marks Total Marks out of 4.)

21
7. Presentation

8. Viva

(A) (B)

Process and Product Assessment (6 marks) Individual Presentation Total Marks 10

/Viva (4 marks)

22