/projects

Meeting Management System

SQL Server database and accompanying tools for scheduling meetings, managing employees, rooms, invitations, documents, minutes and notifications within an organization.

Meeting Management System

Highlights

  • Meeting management (Reunions table) with scheduling, host, room, agenda and duration
  • Employee, role and company management (Employes, Roles, Entreprises tables)
  • Invitations and attendance tracking with disponibilite and presence fields
  • Documents and minutes management with Documents, Reunions_Documents and Compte_Rendu
  • Notifications system and helper tables for invitation notifications and status tracking
  • Stored procedures and user-defined functions for reports and room availability (SalleDisponible, GetDureeTotaleReunionsEmploye)

Technologies

SQL ServerT-SQLStored ProceduresUser-Defined FunctionsC (CLI)