Skip to content

Latest commit

 

History

History
31 lines (26 loc) · 1.84 KB

README.md

File metadata and controls

31 lines (26 loc) · 1.84 KB

Database Management System for Hybrid Educational Services

Authors

  • Jakub Kaliński
  • Michał Szymocha
  • Emil Żychowicz

Database schema

Project Overview

This project implements a database system for a company offering various training programs, including webinars, courses, and study programs. The system manages event scheduling, participant registrations, payments, and reporting while ensuring data integrity and access control.

Features

  • Reporting & Analytics: Generates financial reports, attendance records, and conflict detection reports.
  • User Roles & Permissions: Admins, instructors, and participants have defined access rights.
  • Event Management: Tracks webinars, courses, and study programs with details like schedule, location, and instructor.
  • Payment Handling: Supports order creation, tracking, and integration with an external payment provider.
  • Attendance & Completion Tracking: Verifies participation and completion criteria for certifications.
  • Data generator: Python script generates data in topological order to ensure data consistency.

Files

  • database_flow/ – contains SQL code showing how different views, procedures, and triggers work together.
  • indexes/ – database index definitions for query optimization.
  • procedures/ – SQL scripts for stored procedures.
  • roles/ – definitions of user roles and database permissions.
  • triggers/ – SQL triggers ensuring data consistency.
  • views/ – SQL views for easier reporting and data access.
  • dataGenerator.py – script for generating data.
  • database_schema.png – database schema diagram.
  • documentation.pdf – full project documentation.