dagmawileulseged-ctrl/Vehicle-Management-System-

A SQL Server database system for managing vehicle registration, plate changes, ownership transfers, and traffic enforcement across Ethiopia's regions. # Vehicle Management System — Database A relational database schema for a national vehicle registration and management system, designed for the Ethiopian context. Built with **Microsoft SQL Server (T-SQL)**. ## Overview This database models the full lifecycle of vehicle registration, plate management, ownership transfers, traffic enforcement, and compliance tracking across all regions of Ethiopia. ## Features - **Vehicle & Plate Management** — Register vehicles, assign plates, track plate generations (old/new), and record plate changes with full history. - **Owner & Driver Records** — Support for individual, corporate, government, diplomatic, NGO, and UN ownership types. - **Regional Coverage** — Structured around Ethiopia's 11 administrative regions and registration offices. - **Traffic Enforcement** — Record penalties, violations, accidents, and assign traffic officers. - **Compliance Tracking** — Monitor insurance status, vehicle inspections, and unpaid penalties before allowing plate changes. - **Appointments & Notifications** — Schedule plate changes, inspections, and registrations; notify owners via email, SMS, or push. - **Audit Logging** — Full audit trail on all data operations. - **Analytical Queries** — Pre-built queries for regional conversion rates, revenue reports, office performance metrics, and compliance dashboards. ## Database Schema | Table | Description | |---|---| | `Region` | Ethiopia's 11 administrative regions | | `RegistrationOffice` | Regional vehicle registration offices | | `Owner` | Vehicle owners (individuals, corporates, government, etc.) | | `Driver` | Licensed drivers with license category and expiry | | `Vehicle` | Core vehicle records (chassis, make, model, fuel type) | | `PlateCategory` | Plate types (private, commercial, government, diplomatic, etc.) | | `Plate` | Individual plate records with generation and status | | `VehicleOwnerHistory` | Full ownership transfer history | | `PlateChangeHistory` | History of all plate c …