Gyan Deep Shiksha Bharti

COMPUTER SCIENCE (083)

PROJECT FILE
ON

PREPARED BY: HARE KRISHAN

TRIPATHI SUBMITTED TO:
Mr. Sumit Garg
Roll No: PGT(CS)

XII

Session: 2023-24
 TABLE OF CONTENTS

 Certificate
 Acknowledgement
 About Project
 Coding

 Requirements

 Bibliography
 Certificate of Completion

This is to certify that HARE KRISHAN

TRIPATHI of Class XII session 2023-24 of Gyan
Deep Shiksha Bharti has successfully completed the
project work under my supervision. The student has
taken proper care and shown utmost sincerity in
completion of this project work.
It is certified that this project is up to my
expectation and as per the guidelines issued by
CBSE, New Delhi.

__________________ __________________
 Acknowledgement
I would like to express my sincere gratitude to all those
who have contributed to the successful completion of my
Class XII Computer Science Project.
First and foremost, I would like to thank my Computer
Science teacher, Mr. Sumit Garg, for their invaluable
guidance and mentorship throughout this project. Their
expertise, patience, and willingness to address my doubts
have been instrumental in shaping this project.
I am also thankful to our school principal, Mrs. Rajni
Nautiyal, for providing me with the opportunity to
undertake this project and for the facilities and resources
made available to me.
I would like to acknowledge the assistance and
cooperation of my classmates and friends who provided
valuable insights and feedback during the project's
development.
Furthermore, I extend my gratitude to my parents and
family for their unwavering support, encouragement, and
understanding throughout this project.
Finally, I would like to thank the Central Board of
Secondary Education (CBSE) for designing a curriculum
that encourages practical learning and project-based
assessments, which have allowed me to develop valuable
skills and knowledge.
 About Project

 Introduction of Project
 Purpose of the project
 Working of this software
 Software features
 INTRODUCTION OF THE PROJECT

In an era characterized by rapid technological

advancements, the automotive industry stands at the
forefront of innovation, with a growing emphasis on data-
driven solutions to enhance user experiences. Our project
AUTOMOBILE SERVICES , represents a
groundbreaking initiative aimed at transforming
traditional automobile services by seamlessly integrating
user-generated data into the heart of the automotive
maintenance landscape.

At its core, our project involves the development of an

intuitive and user-friendly interface that empowers
vehicle owners to effortlessly input and share relevant
data. From routine maintenance schedules to real-time
diagnostics, automobile services acts as a centralized
repository, collecting and collating diverse datasets to
create a comprehensive profile for each registered
vehicle.
 PURPOSE OF THE PROJECT

The purpose of the "Automobile Services Data Management

System" project is to create a comprehensive and efficient platform
for managing and storing data related to automobile services. The
project aims to streamline the process of collecting, organizing, and
accessing information provided by users seeking automotive
services.

Objectives:-
User Data Collection: The project will facilitate the collection of
essential data from users, including vehicle details, service
requirements, and contact information. This process aims to create a
user-friendly experience for customers seeking automotive services.
Service Request Management: The platform will enable users to
submit service requests, detailing the specific issues or maintenance
tasks they require for their vehicles. This feature ensures that
service providers receive accurate and detailed information about
the customer's needs.
Automated Record-keeping: The project will implement
automated record-keeping functionalities to maintain a
chronological history of services provided to each customer.
 WORKING OF THE SOFTWARE

 Database Connection: Establishes a connection to a MySQL

database named "AUTOMOBILE_SERVICES" using the
pymysql library. The database connection parameters include the
host, user, password, and database name.

 Customer Information Input: Prompts the user to enter personal

information such as name, city, phone number, vehicle type, and
vehicle model number.

 Available Services: Displays a list of available automobile

services stored in the available_services list.

 Service Selection: Asks the customer to choose a service by

entering the corresponding number.

 Service Information: Based on the selected service number,

provides information about the selected service and its associated
cost. The service information and cost are displayed using a series
of if-elif-else statements.

 Customer Thank You Message: Prints a thank you message to the

customer, acknowledging the recorded information and informing
them about future contact for service.

 Database Insertion: Uses an INSERT query to add the customer's

information (name, city, phone number, vehicle type, and model
number) into the "CUSTOMER_DETAIL" table in the database.

 Database Query and Display: Executes a query to select all data

from the "CUSTOMER_DETAIL" table and fetches the results.
Prints the retrieved data, including the newly inserted customer
information.

 Database Commit and Closure: Commits the changes to the

database (ensures that the data is permanently stored).
 Closes the database connection to free up resources.

 Note on Invalid Service Selection: If the customer enters an

invalid service number, it informs them to select a valid service.
 FEATURES OF THE SOFTWARE

User Input Handling: The software prompts the user to input various
details such as name, city, phone number, vehicle type, and model
number, ensuring that it collects necessary information for the service.

Service Selection: Users can choose a service from a list of available

services by entering the corresponding service number. This allows for
customization based on the specific needs of the customer.

Service Information and Pricing: Provides detailed information about the

selected service along with its associated cost. This helps the customer
understand the services they are opting for and the corresponding charges.

Customer Thank You Message: After recording customer information and

service preferences, the software expresses gratitude to the customer and
assures them of future contact for service.

Database Query and Display: Retrieves and displays customer information

from the database, demonstrating the software's ability to interact with a
persistent data store.

Integration with External Library: Utilizes the pymysql library for

interacting with the MySQL database, showcasing the ability to integrate
external libraries for specific functionalities.
CODING
 Python code

import pymysql

# Establish a connection to the MySQL database

conn = pymysql.connect(host="localhost",
user="root", password="mysql",
database="AUTOMOBILE_SERVICES")

cursor = conn.cursor()

# Prompt the customer to enter their information

customer_name = input("Please enter your name:
")
city = input("Please enter your city: ")
phone_no = input("Please enter your phone
number: ")
vehicle_type = input("Please enter your vehicle
type: ")
model_no = input("Please enter your vehicle model
number: ")

# List of available services

available_services = [
"1. Oil Change",
"2. Tire Rotation",
"3. Brake Inspection",
"4. Engine Tune-Up",
"5. Transmission Service",
"6. Air Conditioning Repair",
"7. Other Repairs",
]

# Display available services

print("\nAvailable services at our automobile
service station:")
for service in available_services:
print(service)

# Asking the customer to select a service by

number
selected_service = int(input("\nPlease enter the
number of the service you would like to choose: "))

#Giving information to the customer on the basis

of selected service
if selected_service == 1:
print("the price for the oil changing is 700.00
Rs")
elif selected_service == 2:
print("the price for the inspection of tire rotation
is 300.00 Rs")
elif selected_service == 3:
print("the price for inspection of your brakes is
575.00 Rs")
elif selected_service == 4:
print("the price for engine tune up is 1540.00
Rs")
elif selected_service == 5:
print("the price for transmission service is
500.00 Rs")
elif selected_service == 6:
print("the price for A.C. repairing is 980.00 Rs")
elif selected_service == 7:
print('''the price for other repairs may vary
according
to your needs...
please contact at the centre''')
else:
print("\nInvalid service number. Please select a
valid service.")

# Thank the customer

print(f"Thank you {customer_name} We have
recorded your information.")
print(f"We will contact you on {phone_no} for
service of your {vehicle_type} And model:
{model_no}........")

print('''For other repairs, you have to contact the

service center.
You will be charged accordingly.....''')

# Insert customer information into the database

using an f-string
insert_query = f"INSERT INTO CUSTOMER_DETAIL
(customer_name, city, phone_no, vehicle_type,
model_no) VALUES ('{customer_name}', '{city}',
'{phone_no}', '{vehicle_type}', '{model_no}')"
cursor.execute(insert_query)
conn.commit()
print("Customer information has been saved to the
database.")

# printing data recieved in database

cursor.execute("select * from
CUSTOMER_DETAIL")
data=cursor.fetchall()
count=cursor.rowcount
for row in data:
 print(row)

# Close the database connection

conn.close()
MySQL code
 REQUIREMENTS

 HARDWARE REQUIRED

 Printer, to print the required

documents of the project
 Compact Disc Driver
 Keyboard and Mouse
 Monitor
 Processor: Intel Core i3 or above
 Ram : 4 GB+
 Hard disk : 512 GB or above

 SOFTWARE REQUIRED

 Operating system: Windows 7 or its

successors.
 Python IDLE, for execution of program.
 Microsoft Office for presentation of
output.
 BIBLIOGRAPHY
1. Guttag, John V. "Introduction to Computation and
Programming Using Python." MIT Press, 2016.

2. Lutz, Mark. "Learning Python: Powerful Object-Oriented

Programming." O'Reilly Media, 2013.

3. McKinney, Wes. "Python for Data Analysis." O'Reilly Media, 2017.

4. Grus, Joel. "Data Science from Scratch: First Principles with

Python." O'Reilly Media, 2019.

5. Van Rossum, Guido. "The Python Programming

Language." Python Software Foundation, 2021. [Online]
Available at: https://www.python.org/doc/essays/blurb/.

6. Rossum, Guido van. "PEP 8 -- Style Guide for Python Code."

Python Software Foundation, 2021. [Online] Available at:
https://www.python.org/dev/peps/pep-0008/.

7. W3Schools. "Python Tutorial." W3Schools.com, 2021.

[Online] Available at: https://www.w3schools.com/python/.

8. Various online documentation, tutorials, and forums that

provided essential guidance and code snippets during the
project development process.