This project is a web application that provides information about car models, built using PHP, HTML, and CSS, without using any framework.
The interface is intentionally simple, as the main focus was placed on the design of the MySQL database to which the website is connected, as well as on the operations performed on it. Basically, through this web application, the user can view the information stored in the database about the selected car model in a more user-friendly format.
The relational diagram (ERD – Entity Relationship Diagram) can be seen in the following video:
The project was designed so that, through the website, the user can perform database queries that illustrate the basic operations of relational algebra, namely:
- At least one operation for union, difference, selection, projection, and join
- Two join operations that involve at least two other intermediate operations (union, difference, selection, projection) performed before the join
Additionally, the database has gone through the normalization process and was brought up to the Third Normal Form (3NF).
In the following video, you can see how a part of the web application looks
(please be patient, as the GIF loads slowly and may take 1–2 minutes to appear):
- Clone the repository
git clone https://github.com/andrei-vasile-dev/AutoDB.git- Configure the database
• Create a MySQL database
• Import the masinibd.sql file
• Update the config.php file with your MySQL credentials
- Run the application
• Place the project on a local server (e.g. XAMPP, WAMP, MAMP)
• Access it in the browser at:
http://localhost/project-name/