Law Firm Database Management System

Overview

A comprehensive database management system for an imaginary law firm with a user-friendly GUI.

This project implements a complete database management system for an imaginary law firm, featuring a modern GUI built with customtkinter. The system manages lawyers, clients, lawsuits, departments, and counseling appointments with robust data validation and visualization capabilities. It includes database triggers to enforce gender diversity policies, comprehensive search and filtering options, and statistical analysis tools to visualize case outcomes and lawyer performance.

Features

• Secure login system with role-based access control
• Complete CRUD operations for lawyers, clients, lawsuits, and departments
• Interactive data visualization with Matplotlib for case statistics and lawyer performance
• Database triggers to enforce company policies (e.g., gender diversity requirements)
• Advanced filtering and search capabilities across all entities
• Data validation using regular expressions to ensure data integrity
• Client fee calculation and financial tracking system
• Comprehensive case outcome analysis with verdict statistics