PROJECT REPORT
Submitted in Fulfillment of Class XII Syllabus Requirement
in
COMPUTER SCIENCE (083)
Topic: ____________________________
CERTIFICATE
Certified that this is the bonafide record of project work carried out by
___ Roll No._________
of Class XII of this school during the year 2025-2026.
Teacher-in-Charge Principal Examiner
CAR DEALERSHIP
MANAGEMENT
NAME: ANNA C bINu
CLASS: xII G
INDEX
Serial no:
1 Acknowledgement
2 Introduction
3 Development Tools
4 Synopsis
5 Source Code
6 Output
7 Bibliography
ACKNOWLEDGEMENT
Apart from the efforts by us, the success of this project
depends largely on the encouragement and guidelines of
many others. We take this opportunity to express our
gratitude to all who have been instrumental in the
successful completion of this project.
Primarily, we would like to thank God almighty for
giving us the strength to successfully complete this
project. We express our heartfelt gratitude to our parents
for their constant encouragement while carrying out this
project. We would also like to thank our school Principal
Fr Sabu Koodappatu CMI, and our Computer science
teacher Mrs. Suma Alex whose valuable guidance have
helped us in the completion of this project.
The guidance and support received from all others who
contributed to this project, were vital for the success of
the project. We are grateful for their constant support and
guidance.
INTRODUCTION
The Program is a robust and user-friendly database
manager in python which efficiently capture and
organize key information about customers and their car
purchases. This program allows for the input and display
of important details.Upon receiving this information, the
program will systematically organize and present the data
in a structured, clear, and visually appealing format. The
output will be formatted for easy review and analysis,
ensuring the details are well-organized and accessible.
DEVELOPMENT TOOLS
PYTHON:
Python is a high-level, interpreted programming language
known for its simplicity and readability. Created by
Guido van Rossum and first released in 1991, Python
emphasizes clean syntax, making it an ideal choice for
beginners and professionals alike. It supports multiple
programming paradigms, including procedural, object-
oriented, and functional programming. Python is widely
used in various fields such as web development, data
science, artificial intelligence, machine learning,
automation, and more. Its extensive standard library and
vibrant community contribute to its versatility and
popularity, making it one of the most in-demand
programming languages in the world today.
FEATURES OF PYTHON:
➢ Easy to Learn and Read – Simple syntax resembling
English makes it beginner-friendly.
➢ Interpreted Language – Code is executed line by line,
making debugging easier.
➢ Dynamically Typed – No need to declare variable types;
they are inferred at runtime.
➢ Object-Oriented – Supports object-oriented programming
with classes and objects.
➢ High-Level Language – Abstracts complex details like
memory management.
➢ Extensive Standard Library – Includes modules for file
handling, math, web services, and more.
➢ Cross-Platform – Runs on various operating systems like
Windows, macOS, and Linux.
➢ Large Community Support – Strong online community
for help, libraries, and frameworks.
SQL:
SQL (Structured Query Language) is a standardized
programming language used to manage and manipulate
relational databases. It is essential for performing tasks
such as querying data, updating records, inserting new
entries, and deleting data from databases. SQL allows
users to create and modify database structures (using
commands like CREATE, ALTER, and DROP) and
control access to the data. Its syntax is relatively
straightforward and widely adopted in industries that
handle large volumes of structured data, such as finance,
healthcare, and e-commerce. SQL plays a crucial role in
data analysis, reporting, and backend development,
making it a foundational skill for data professionals and
developers alike.
FEATURES OF SQL:
➢ Data Querying – Retrieve specific data using powerful
commands like SELECT.
➢ Data Manipulation – Insert, update, and delete records
with INSERT, UPDATE, and DELETE.
➢ Data Definition – Create and modify database structures
using CREATE, ALTER, and DROP.
➢ Data Control – Manage user access and permissions with
GRANT and REVOKE.
➢ Transaction Control – Ensure data integrity using
COMMIT, ROLLBACK, and SAVEPOINT.
➢ Standardized Language – Follows ANSI and ISO
standards, widely used across database systems.
➢ High Performance – Optimized for efficient data retrieval
and manipulation.
SYNOPSIS
1. Structured Data Input: The program prompts the
user to input customer names, cities, car models, and
prices in an orderly and guided sequence.
2. Data Presentation: Once the information has been
collected, the program will display the data in an easily
readable format, such as a neatly organized table or list.
3. Sorting and Organization: The program provides the
ability to sort the data based on specific attributes, such as
car price or customer location, facilitating easy
comparison and analysis.
4. Clear and Professional Output: The final display of
customer details will be formatted with clarity and
precision, ensuring the data is both comprehensible and
professional in appearance.
SOURCE CODE
import mysql.connector as db
con=db.connect(host='localhost',user='root',password
='12345',database='annaxig')
cur=con.cursor()
cur.execute("create table if not exists
CARDEALERSHIP(CUSTOMERNO INT
PRIMARY KEY,NAME VARCHAR(20),MODEL
VARCHAR(20),CITY VARCHAR(20),PRICE
INT);")
print('-'*32,"Car Dealership",'-'*32)
n=int(input("enter number of times"))
for i in range (n):
no=int(input("enter customer id"))
name=input("enter name of customer")
car=input("enter model of the car")
city=input("enter city ")
price=int(input("enter price of the car"))
cur.execute('insert into CARDEALERSHIP
values(%s,%s,%s,%s,%s);',(no,name,car,city,price))
con.commit()
print("menu")
print("1-display")
print("2-search")
print("3-pricewise")
print("4-citywise")
print("5-add more")
print("6-update")
print("7-delete a customer")
print("8-about us")
print("9-exit")
c=int(input("enter choice"))
def update():
i=int(input("enter customer no. to search"))
na=input("enter new name of customer")
Ca=input("enter new car ")
CITY=input("enter new city name")
pri=int(input("enter new price of car"))
cur.execute('UPDATE CARDEALERSHIP SET
name = %s,model=%s,city=%s,price=%s WHERE
customerno=%s;',(na,Ca,CITY,pri,i))
if c==1:
cur.execute("select*from CARDEALERSHIP;")
carlist=cur.fetchall()
print("no\tname\tcar\tcity\tprice")
for i in carlist:
print(i[0],i[1],i[2],i[3],i[4],sep='\t')
if c==2:
i=int(input("enter customer no. to search"))
cur.execute('select*from CARDEALERSHIP
where customerno=%s;',(i,))
deets=cur.fetchall()
for i in deets:
print(i[0],i[1],i[2],i[3],i[4],sep='\t')
if c==3:
cur.execute('select*from CARDEALERSHIP
where price>1000000;')
pricewise=cur.fetchall()
for i in pricewise:
print(i[0],i[1],i[2],i[3],i[4],sep='\t')
if c==4:
j=input("enter city to search")
cur.execute('select*from CARDEALERSHIP
where city=%s;',(j,))
ci=cur.fetchall()
for i in ci:
print(i[0],i[1],i[2],i[3],i[4],sep='\t')
if c==5:
d=int(input("enter id of customer"))
na=input("enter name of customer")
Car=input("enter car ")
CITY=input("enter city name")
price=int(input("enter price of car"))
cur.execute('insert into CARDEALERSHIP
values(%s,%s,%s,%s,%s);',(d,na,Car,CITY,price))
con.commit()
cur.execute('select*from CARDEALERSHIP;')
z=cur.fetchall()
for i in z:
print(i[0],i[1],i[2],i[3],i[4],sep='\t')
if c==6:
update()
cur.execute('select*from CARDEALERSHIP;')
z=cur.fetchall()
for i in z:
print(i[0],i[1],i[2],i[3],i[4],sep='\t')
if c==7:
def delete():
i=int(input("enter customer no. to delete"))
cur.execute('DELETE FROM
CARDEALERSHIP WHERE customerno = %s',(i,))
delete()
cur.execute('select*from CARDEALERSHIP;')
z=cur.fetchall()
for i in z:
print(i[0],i[1],i[2],i[3],i[4],sep='\t')
if c==8:
f=open("ANNA.txt","r")
s=f.read()
print('-'*35,'ABOUT US','-'*35)
print(s)
f.close()
if c==9:
i=input("enter yes to exit from manual")
if i=='yes':
print("THANK YOU!!")
OUTPUT
Menu:
Display table:
Searching for a customer:
Searching pricewise:
Searching citywise:
Adding customers:
Updating :
Deleting customers:
About Us:
BIBLIOGRAPHY
• Textbook of Computer Science with Python- class XII, by V K
Pandey, D K Dey
• NCERT Computer Science Text, class XI
• www.python.org
• www.mysql.com
THANK YOU
