We aim to create an application which is easy to access and user friendly. For this application we used the backend as MySQL to store the data which is used in the application and for the user interface, we have used PHP and HTML. Three kinds of people are able to use this application – Inventory Manager, Showroom Sales Manager and Customer.
Inventory Manager is tasked with ordering raw materials from the suppliers in the inventory as well as placing the order for manufacturing of cars that will be placed back in the inventory. The Showroom Sales Representative is tasked with adding the cars to the showroom. The customer is able to buy the car(s) from the showroom by reading the details of cars.
Problem Definition:
Model and implement a robust and attractive Showroom Management - Database Management System. The application should be able to save data of all the entities present in the system and be able to manipulate it.
The following functionalities are supposed to be covered in the project:
I. Create a new raw material
II. Create a new car
III. Get raw material
IV. Manufacture a car
V. Deliver a car
VI. Buy a car
Tools:
I. MySQL Workbench 8.0
II. XAMPP Server
Technologies:
I. MySQL
II. HTML
III. CSS
IV. PHP