AutoQuery is a complete SQL Server project designed to manage vehicle registrations, ownership transfers, and compliance tracking. This system simulates a real-world DMV-like database, using advanced SQL features like stored procedures, triggers, and audit tables to ensure accurate and secure data handling.
- ✅ Structured Vehicle & Owner Registration
- 🔄 Audit Trails via Triggers — Tracks changes to ownership
- ⚙️ Stored Procedures — Automates data entry, transfer, and deletion
- 🧾 Audit Tables — Maintains logs for historical compliance
- 🔍 Supports Reporting — Easily extendable to Power BI / analytics
- SQL Server (SSMS / Azure SQL)
- T-SQL: Stored Procedures, Triggers, Views
- Visual Studio / GitHub for Versioning
- (Optional for future): Power BI for visualization
Vehicles: Details of registered vehiclesOwners: Personal and contact informationVehicleOwnership: Links each vehicle to current/past ownersVehicleOwnershipAudit: Captures audit logs via triggers
InsertVehicle,InsertOwner,AssignOwnershipTransferOwnershipand ownership-end logic- Simplifies CRUD operations with parameterized input
-
Triggers on
VehicleOwnershiptable capture:- Insertions (new ownership)
- Updates (transfers)
- Deletions (revocations)
-
All actions are logged into the
VehicleOwnershipAudittable for historical tracking and compliance.
A visual overview of the system's database schema:
- 🚀 90% reduction in manual updates through automation
- 📈 Fully auditable system with built-in integrity
- 🔍 Supports real-time queries for reporting tools
Uday Sai Kiran Reddy Gadam
📧 udaysaikor@gmail.com
🎓 MS in Business Analytics & AI, University of Texas at Dallas
🌟 Star this project if you found it useful or would like to build on it!