The marketplace
Collection of Automobile Repositories (C.A.R.) was designed as a single place to explore vehicle listings from multiple dealerships. The requirements covered searches by vehicle type, color, year, price, mileage, and dealership location, alongside comparison tools, customer accounts, and administrator inventory management.
My contribution
I helped write and develop the software description and the functionality names and descriptions in the team’s requirements specification. This work translated the marketplace idea into concrete user and administrator tasks that the database design needed to support.
Database design
The team modeled users, administrators, customers, dealerships, vehicles, advertisements, and reviews, then mapped those relationships to relational tables with keys and references. The schema evaluation considered how separating reviews from vehicle and customer information could reduce duplicated data and make updates easier to manage.
SQL implementation and outputs
The project files include table-creation scripts, sample vehicle and dealership data, a MySQL database export, update and deletion exercises, and database views. The original screenshots show a conditional vehicle-price update and a dealership-popularity view that groups dealership information with click counts. A Next.js front-end scaffold is also present; the main demonstrated deliverable here is the database and its SQL outputs.
Database and web application stack
The team project translated vehicle-marketplace requirements into an entity-relationship model and a MySQL relational schema. SQL scripts populated customer, vehicle, dealership and user records, then exercised joins, aggregation, grouping and database views. The accompanying web application used React and Next.js with Tailwind CSS. My documented contribution focused on requirements and functionality specification; the schema, query outputs and web code describe the wider team implementation.
