Vehicle showroom Database Management System Project, provides solution for showrooms for organizing data using software application. This software application helps administrator to update data in step by step process while selling vehicle to customer. Using this system management team can update customer’s information, vehicle information, payment details, Insurance details, take orders. etc. Vehicle showroom software is presently used in every car, bike showrooms for computerizing entire system. This software package includes inventory management module, daily management details, image uploads, sales reports. There is no other scripting or server end management for this system. This project describes the complete process of selling a vehicle to a customer from the dealer’s showroom. Before selling, the vehicle belongs to the fixed asset of the dealer’s showroom. So the main point of this scenario is posting the vehicle from a fixed asset to a current asset. While executing the process, the dealer can manually maintain the vehicle business transaction type, which means, the vehicle can be set as a new or used vehicle to sell to the customer. This scenario shows the process of new vehicle sales.
IDENTIFYING ENDUSERS • Admin • Seller • Customer • Dealer
IDENTIFYING ENTITIES • Admin • Dealer • Showroom • Vehicle • Customer • Sales • Image • Tax
IDENTIFYING ATTRIBUTES: ADMIN DEALER SHOWROOM VEHICLE Ad_id Ad_name User name Password Last login Contact No. Status
D_id Name User name Password Companyname Address Status Last login
Sh_id Sh_name Quantity Address Contact info State PIN Status
V_id V_description Status V_name V_cost V_Type V_Model CUSTOMER SALES IMAGE TAX_DETAILS Cu_id Name Gender Address Password Email
S_id Order_date Del_date V_cost status
Img_id Img_path Img_name Deafault_time
Tax_id Tax Description Status