Project on automobile service station management system is designed on waterfall model with three tire architecture. This web application will have features like insurance management, vehicle service management, customer management, verification management.

Introduction:

Customer service software plays important role in managing large company’s customer data with service management and employee management. There are many automobile companies where each company will have many service centers all over the country. This CRM software is useful for handling customer service information.  

Project abstract:

CRM software is developed for an automobile industry this can be used of cars or two wheels with few modifications. Using this application management team can update vehicle owners all details with registration number, services, spare parts, insurances, these details are updated to database which can be useful for further verification for insurance companies.

Database Design:

In this project we are using oracle as database which can be modified to other database formats also and change drivers.

There are nine tables in this application few are explained below

User details table consists of customer id, user name, password, question and answers and date of birth with email id.

Employee details table will store employee’s information with id, name, email, phone number, designation.

Other tables are login details, employee messages, employee block details, status change, and product details.

Software requirements:

Client – side Scripting                 : Javascript

Programming Language                    : Java

Backend Database                        : Oracle/SQL Server/MY SQL/MS Access 

Download Automobile Service Station Management Project source code in java with project report.