2025 -2026
Project
Report
Prepared by :
Vanshika Bhardwaj
Class : X
Subject : Computer / Information
Technology
Acknowledgement
I would like to express my sincere thanks to my teacher for
guiding me in completing this project. I am also thankful to
my school for providing me the opportunity to learn and
prepare this project. Lastly, I thank my parents and friends for
their support.
Certificate
This is to certify that Vanshika Bhardwaj of class 10th has
successfully completed the project titled “Customer Billing
Database” under my guidance during the session 2025 –
2026.
Teacher’s Signature
Date: January 27, 2026
Index
1. Introduction
2. Objective
3. What is a Database?
4. What is a Table?
5. What is a Field?
6. Data Type
7. Tables Used in Project
8. Primary Key
9. Foreign Key
10. Relationship Between Tables
11. Conclusion
1. Introduction
In today’s world, every business needs to maintain customer records and billing details properly. If these
records are stored on paper, mistakes may happen and data can be lost. Therefore, we use a Database to
store information safely and in an organized manner.
2. Objective of the Project
The main objectives of this project are:
• To store customer information properly
• To maintain billing and payment details
• To check total billed amount and paid amount
• To connect customer details with state information
• To manage customer credit limit efficiently
3. What is a Database?
A Database is a collection of related data stored in a computer system. It helps us to store, search,
update, and manage the data easily.
4. What is a Table?
A Table is a structure in a database where information is stored in rows and columns.
• Row = Record (one full customer entry)
• Column = Field (CustID, Name, Mobile etc.)
5. What is a Field?
A Field is a column in a table which stores a specific type of information. Example: Customer Name,
Address, Phone Number etc.
6. Data Type
Data Type tells what kind of value can be stored in a field.
• Numeric Used for numbers
• Varchar/Text Used for words and text
• Set relation between Tables (CustID – Customer to BillDetails and
StateID – Customer to State)
Table 1: CUSTOMER (Customer Details Table)
Create the CUSTOMER table with the following fields: CustId (NUMERIC), CName (VARCHAR), Add1
(VARCHAR), STATEID (NUMERIC), Phone (NUMERIC), Mobile (NUMERIC), ContactPerson (VARCHAR),
CreditLimit (NUMERIC).
Field Name Data Type Description
CustID Numeric Unique ID for each customer
CName Varchar Customer Name
Add1 Varchar Customer Address
STATEID Numeric State ID (connected with State table)
Phone Numeric Customer Phone number
Mobile Numeric Customer Mobile number
ContactPerson Varchar Contact person name
CreditLimit Numeric Maximum credit limit
Table 2: BILLDETAILS (Billing Details Table)
Create the BILLDETAILS table with the following fields: CustID (NUMERIC), Quotation (NUMERIC), Challan
(NUMERIC), Bil (NUMERIC), Amount_Billed (NUMERIC), Amount_Paid (NUMERIC).
Field Name Data Type Description
CustID Numeric Customer ID (linked with CUSTOMER table)
Quotation Numeric Quotation number (Estimate)
Challan Numeric Challan number (Delivery slip)
Bill Numeric Final bill number
Amount_Billed Numeric Total bill amount
Amount_Paid Numeric Total paid amount
Table 3: STATE (State Master Table)
Create the STATE table with the following fields: StateID (NUMERIC), StateName (VARCHAR)
Field Name Data Type Description
StateID Numeric Unique State ID
StateName Varchar State Name
8. Primary Key
A Primary Key is a field that uniquely identifies each record in a table.
• CUSTOMER table CustID is Primary Key
• STATE table StateID is Primary Key
9. Foreign Key
A Foreign Key is a field that connects one table with another table.
• CUSTOMER table STATEID is Foreign Key
• BILLDETAILS table CustID is Foreign Key
10. Relationship Between Tables
Relationship 1:
[Link] [Link] (Shows which state the customer belongs to.)
Relationship 2:
[Link] [Link] (Shows which bill belongs to which customer.)
11. Conclusion
This project helps to store customer details and billing records in an organized database system. It makes
billing easy, fast, and error-free. It also helps to track the paid amount, pending amount, and credit limit
properly.
• Generate a query that will display the records of Customer Table along
with statename and Billing details of the customer. The query should
calculate the balance amount of the customer.
SELECT
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
([Link] - [Link]) AS BalanceAmount
FROM CUSTOMER c
JOIN STATE s ON [Link] = [Link]
JOIN BILLDETAILS b ON [Link] = [Link];
• This query joins CUSTOMER, STATE, and BILLDETAILS tables based on the relationships.
• It outputs each billing record per customer showing how much is billed, paid, and the outstanding
balance.
• Design a Form to display the customer details.
• Design a form (using your database management system's form tool or a programming interface) that
shows:
o Customer Name
o Contact Person
o Mobile
o State Name (from STATE table)
o Credit Limit
o Billing Details (Amount Billed, Amount Paid, Balance)
• The form should be connected to the CUSTOMER table and use a sub-form or related section for
billing details linked by CustID.
• Update any CustID in CUSTOMER table and verify if the same gets
updated in BILLDETAILS table.
• Normally, updating primary keys that are linked with foreign keys requires cascading
updates in the database constraints.
• To update CustID in CUSTOMER and reflect in BILLDETAILS:
o Ensure the foreign key in BILLDETAILS has ON UPDATE CASCADE option.
o Example to update CustID from old value to new value:
UPDATE CUSTOMER
SET CustID = NewCustID
WHERE CustID = OldCustID;
• BILLDETAILS CustID will update automatically if foreign key constraint is set with ON
UPDATE CASCADE.