Cs Ipv

coMPUTER ScIENcE
INVESTIGAToRY PRoJEcT
Name: Vedant nadagouda

STD: XII
Div: A
Roll No: 15
Group Members: Vijay , shlok , himanshu.
INDEX
Sr. No Topic
1 Acknowledgment
2 Aim
3 Introduction
4 Hardware and Software Requirements
5 Modules Used
6 Procedure
7 ER Diagram
8 Flowchart of code
9 Source Code
10 Output Code
11 Learning Outcomes
12 Bibliography
ACKNOWLEDGMENT
I express my gratitude towards my Principal, Mrs Radhmani Iyer for providingus the opportunity to
do research and investigate on this project.
I express my gratitude towards my Senior Secondary Coordinator, Mrs NeetaSingh for motivating
us for the completion of this project.
I sincerely thank my Computer Science teacher, Mrs Supriya Mukherjee, forthe moral support and
guidance to find the mistakes in this project.
I also thank to my Group member for his help and contribution to completethis project.
AIM
Car Showroom Management System
To insert, update, delete, display and search the records of the car details along with the
customers’ details.
INTRODUCTION
Introduction to Python:
Python is object oriented programming language, which was developed by Guido van Rossum in 1991,
It is a very high level programming language yet aspowerful as many other middle level not so high
level languages like C, C++, Java. It is based on or influenced with two programming languages:
1. ABC language, teaching language created as replacement of BASIC,

2. Modula -3
Python can run equally well on variety of platforms – Windows, Linux/UNIX,Macintosh,

supercomputers, smart phones etc.
Introduction to MySQL:
MySQL is a freely available open source Relational Database Management System (RDBMS) that uses
Structured Query Language (SQL). A single MySQL database can contain many tables at once and
store thousands of individual records. MySQL provides you with a rich set of features that support a
secure environment for storing, maintaining and accessing data. MySQL is a fast, reliable, scalable,
and alternative to many of the commercial RDBMSs availabletoday.
MySQL database system refers to the combination of a MySQL server instance and a MySQL database.
MySQL operates using client/server architecture in which the server runs on the machine containing
databases and clients connected to the server over a network. The server operating system is
usuallya Linux or Windows operating system.
Introduction to MySQL connector:
MySQL Connectors provide connectivity to the MySQL server for client
programs.
Introduction to Topic:
The proposed Car showroom management system is very effective. If someone is interested in buying
any car, then he/she can check all the information related to the car in the given portal. He/she can
even book the test drive within the system. The proposed system also helps the buyer to check which
cars and companies are good for them, by showing them the past reviews about the car/companies.
The proposed system is so helpful and effective.
HARDWARE AND SOFTWARE REQUIREMENTS
1. Hardware Requirements:
i. 64-Bit CPU
ii. 2 CPU Crores
iii. 8 GB Ram
iv. 5 GB free Disk
2. Software Requirements:
i. IDLE Python (3 or 2)
ii. MySQL (Greater than 4.1)
iii. MySQL Connector Python
MODULES USED
MySQL Connector
PROCECURE
1) In MySQL, create a database with name “carshowroom”.

2) Use this database.
3) Create table of car details.
4) Create a table of car details with the following details given below:
i) Car id
ii) Car Name
iii) Car Type
iv) Car price
Insert primary key for car id
5) Create a table of customer details with the following details given below:
i) Customer id
ii) Customer name
iii) Address
iv) Email id
v) Phone no
6) Create a table of transaction details with the following details given below:
i) Customer id
ii) Car id
iii) Transaction id
iv) Transaction no
v) Date of payment
7) Create a python interface to insert, update, delete, display and search records from car details
table.
8) Similarly create a python interface to insert, update, delete, display and search records from
customer details table.
9) Similarly create a python interface to insert, update, delete, display and search records from transaction details
table.
ER Diagram
FLOWCHART
START
Take input
from user
from menu
Perform functions of insert,

Is it one? Yes update, search or delete for car
details table
No
Yes Perform functions of insert,

Is it two?
update, search or delete for
transaction details table
No
Is it three? Yes Perform functions of insert,
update, search or delete for
customer details table
No
No Display error message

Is it four?
Yes
End
SOURCE CODE
Main:-
Car details:-
Customers details :-
Transaction :-
OUTPUT CODE
LEARNING OUTCOMES
1. This project helps to apply programming language in real- worldsituation or

problem.
2. This project had defined and created a relation between the tables.
3. This project helps to communicate to database system using theprogramming
language.
BIBLOGRAPHY
1. Computer Science with Python for Class XI – Sumita Arora.

2. Computer Science with Python for Class XII – Sumita Arora.
3. https://dev.mysql.com/doc/connector-python/en/connector-python-example-
cursor-transaction.html

Cs Ipv

Uploaded by

Copyright:

Available Formats

Cs Ipv

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Cs Ipv

Uploaded by

Copyright:

Available Formats

coMPUTER ScIENcE

Name: Vedant nadagouda

4 Hardware and Software Requirements

Car Showroom Management System

1. ABC language, teaching language created as replacement of BASIC,

Python can run equally well on variety of platforms – Windows, Linux/UNIX,Macintosh,

1) In MySQL, create a database with name “carshowroom”.

Perform functions of insert,

Yes Perform functions of insert,

No Display error message

1. This project helps to apply programming language in real- worldsituation or

1. Computer Science with Python for Class XI – Sumita Arora.

You might also like