Designed and developed a relational database management system for a car showroom using SQL. The project modeled real-world business operations, including vehicle inventory, manufacturers, maintenance workshops, employees, customers, and orders. Implemented normalized database schemas, relationships, constraints, and advanced SQL queries for inventory management, pricing updates, reporting, and operational analysis. The project focused on applying database design principles and optimizing data retrieval through efficient SQL queries without relying on a graphical interface.
Technologies Used:
SQL
MySQL
Relational Database Design
ER Diagram
Database Normalization
Skills:
Database Design
SQL
MySQL
Data Modeling
Relational Databases
Query Optimization
Joins
Stored Procedures
Viewsse Management Systems (DBMS)
