Automobile Management System Project report
Title of the Project
The title of the proposed project is “Automobile Management System”.
PROJECT SOURCE CODE
AUTOMOBILE SHOWROOM MANAGEMENT SYSTEM PROJECT SOURCE
PROJECT REPORT
SPONSORED LINKS
AUTOMOBILE SHOWROOM MANAGEMENT SYSTEM PROJECT REPORT
AUTOMOBILE MANAGEMENT SYSTEM PROJECT REPORT
AUTOMOBILE INVENTORY MANAGEMENT SYSTEM PROJECT FULL REPORT
FREE DOWNLOAD ALL THE PROJECT REPORTS WITH SOURCE CODE FROM HERE
OTHER PROJECTS YOU SHOULD REVIEW
11. COURSE MANAGEMENT SYSTEMS PROJECT
12. KNOWLEDGE OUTSOURCING SYSTEM PROJECT REPORT
INTRODUCTION - Automobile Management System
Sunil Auto Sales Pvt. Ltd. is an Automobile selling company situated at Alambagh Lucknow. The company has dealership of Bajaj Automobiles. The company has also a service point, for providing all types of servicing of bajaj vehicles, also deals with spare parts and accessories of its vehicle.
Company has mainly concerned with three departments: Sales, Service and Parts.
Sales department deals with the selling of new vehicles of bajaj auto. In this department various type of tasks performed at the time of selling a vehicle which are as follows,
Complete detail of the customer such as Name, Address, City.
Detail of vehicle to be purchased.
Payment Mode (Cash/Cheque)
Vehicle Sale Letter
Delivery Challan
The service department manages all type of service records. The task performed
during the service of any bajaj vehicle are as follows,
1. Vehicle details, which has to be serviced
2. Accessories or Parts details to be maintained during servicing
3. Generation of Service bill.
When any type selling or purchasing The parts department concerned with the
The company also deals with the selling or purchasing of accessories or spare parts of it’s vehicle, the parts departments concerned with the following task at this time, are as follows,
1. Complete details of it’s vendor companies, item details like date of purchase, quantity purchase.
2. Invoice generation
3. Stock Updation
The company also employs so many employees and also manages their salary, attendance and their monthly pay sheets. This employee management is distributed Department wise i.e. if any employee concerned with the sales department, sales department will manage his attendance, salary and pay sheet.
For the deep vision about the company present status the department manager draw a chart about its growth every year.
Objective Automobile Management System
The objective of the proposed system is to create a more sophisticated and user-friendly working environment for the three pillars of the company namely sales, service and parts departments. The proposed system optimize the time spend in the activities, performed during the sale, service of any vehicle and selling or purchasing of parts. Proper management of sale data and accurate report generation are the factors, responsible for the growth of any business body.
This system also provides a magical way of dealing with problem of employee attendance and calculating various aspects regarding the employee salary. At any time, Administrator or Director of the company can determine the progress of any department with the help of this system.
As the current trend is of competition age, so that timely and up to date report generation is a very important for any business organization. Through these reports the director of the company can better understand the current status of their organization. So that he can better decide what new strategy should be opt.
The objective of this system can be summarized as,
“To provide a such kind of platform where the company can increase their growth and market strength through the optimization in time and man power with the help of proposed system. Also the company can better target to their goals through the various types of reports and charts generated by the system.
Project Category - Automobile Management System
The project is based on Relational database. Relational databases are one of the most effective ways to organize data. Relational database management systems are applications of mathematical theories that solve how data can be effectively stored.
The rules regarding this implementation and its subsequent optimization will vary widely according to the type of DBMS.
The Database Management Systems available today can be grouped into four types.
These are;
· File Management Systems (FMS)
· Hierarchical Databases (HDS)
· Network Databases (NDS)
· Relational Databases (RDBMS)-The relational database model resulted from an IBM-sponsored research project by Dr. E.F.Codd. The relation model attempts to overcome some the failings of the hierarchical and network database model, and provides easy-to-use and flexible data structure.
· The relational model includes data structure (table), operators that can be used to manage the data in data structure, and some integrity rules that ensure that the data obeys the business rules defined for the system.
· The relational model is based on relational algebra concepts and theory and, in the early days, used some of the same technology to describe the processing that could be performed on the data structures For example, relational theory uses the words "relations" to mean tables, "tuples" to mean rows, and "attributes" to mean columns in table
· Relational database are the most common type of database management systems in use today. Created in 1979, ORACLE is among the products in the field. Other relational database include DB2, Ingress, Informix, Sybase, and SQL Server.
· Another important concept in relational databases is that relationships between tables are not hard-coded in the structure of the data that is there are no pointers in the data to relate one table to another. This means that you can specify the relationships between two sets of data at development time rather than when the tables are first created. This greatly improves the flexibility of the database management system.
· Relational Database Properties- A relational database management system (RDBMS) has the following properties:
· Represents data in the form of tables
· Does not hard-code relationships between tables
· Doesn't require the user to understand its physical implementation
· Provides information about its contents and structure in system tables
· Can be manipulated through SQL commands
· Supports the concept of NULL values