Car Showroom Management System DBMS Project

The Car Showroom Management System is a database management system project that enables the management of inventory, customers, sales, and employees in a car showroom. Here are the complete details of the project:

Overview

The Car Showroom Management System is a web-based application designed to automate the processes involved in a car showroom. The system allows customers to browse through the available cars and place orders online. The system also enables the employees to manage the inventory, customers, and sales efficiently.

Features

The Car Showroom Management System has the following features:

Car Management

  • Car Inventory: Employees can manage the inventory of cars by adding new cars, updating the details of existing cars, and deleting cars from the system.
  • View Cars: Customers can view the available cars on the system along with their details like model, make, year, color, and price.

Customer Management

  • Customer Registration: Customers can register themselves on the system by providing their details like name, email address, phone number, and password.
  • Customer Login: Registered customers can log in to the system using their email address and password.
  • View Profile: Customers can view their profile details and edit them if necessary.

Sales Management

  • Place Order: Customers can place orders by selecting the desired car, specifying the quantity, and providing the delivery address.
  • Order Tracking: Customers can track their orders and view the status of the orders.
  • Manage Orders: Employees can manage the orders by accepting or rejecting them, updating the order status, and marking the orders as completed.

Employee Management

  • Employee Registration: Employees can register themselves on the system by providing their details like name, email address, phone number, and password.
  • Employee Login: Registered employees can log in to the system using their email address and password.
  • View Profile: Employees can view their profile details and edit them if necessary.

Database Design

The database of the Car Showroom Management System consists of the following tables:

Cars Table

  • Car ID (Primary Key)
  • Model
  • Make
  • Year
  • Color
  • Price
  • Image URL

Customers Table

  • Customer ID (Primary Key)
  • Name
  • Email Address
  • Phone Number
  • Password

Sales Table

  • Sales ID (Primary Key)
  • Customer ID (Foreign Key)
  • Car ID (Foreign Key)
  • Quantity
  • Delivery Address
  • Order Date
  • Order Status

Employees Table

  • Employee ID (Primary Key)
  • Name
  • Email Address
  • Phone Number
  • Password

Technologies Used

The Car Showroom Management System is developed using the following technologies:

  • Programming Language: PHP
  • Database Management System: MySQL
  • Web Technologies: HTML, CSS, JavaScript

Conclusion

The Car Showroom Management System is an efficient way of managing the inventory, customers, sales, and employees in a car showroom. It automates the manual processes involved in a car showroom and makes the operations more streamlined and organized.

Leave a Comment