Turning an Oracle database - schema, roles, transactions, and queries - into a product story for rental operations.
This project shipped backend and database operations. The dashboard UI is a concept showing how the data could support a real product.
Car-rental operations need a single source of truth for customers, vehicles, rentals, and maintenance, with accurate availability and cost tracking. We implemented an Oracle relational database to enable operational visibility through queries and views.
The ERD models the business: rentals connect customers, vehicles, and employees, supported by maintenance history and daily cost tracking.
Customer, Vehicle, Rental, and Maintenance track availability, scheduling, and cost per day.
Employee and AvgDailyCost support ownership and pricing trends.
Database capabilities were translated into practical operations tasks.
Find available vehicles, create the rental, and calculate total cost from the date range.
Log events and retain full vehicle maintenance history.
Summarize rentals, average costs, and totals using queries and views.
Customers view, employees insert rentals, supervisors create reporting views.
The database supports one operations view with exactly the data exposed by its schema and queries.
Available, rented, and maintenance counts from Vehicle.Status.
Current rentals with customer, date range, and total cost.
Recent entries with cost and description.
SYS, DEV_USER, CUSTOMER_USER, EMPLOYEE_USER, and SUPERVISOR_USER enforce least-privilege access.
Secure remote access was verified while maintaining permission boundaries.
Operational reports cover customer and employee rentals, vehicles by price, revenue, and a rental-summary view.
Core transactions create rentals, average daily cost records, and maintenance logs.
A cold-backup approach with automated S3 upload supports recovery and reliability.
A production-style backend foundation: structured schema, controlled access, operational queries and views, transaction logic, and a backup plan ready to power an operations dashboard.