sql-triggers

Setting a database to automate the calculations of "Material Resources Planning Algorithm"

enables farmers to manage their profiles, sell agro products, and view system triggers. built with Flask, MySQL, and Bootstrap, it ensures efficient and secure farm management.

A relational database project built with MySQL to manage hotels, rooms, guests, reservations, payments, staff, services, and reviews. The system demonstrates practical DBMS concepts including ER design, normalization, SQL queries, joins, views, functions, stored procedures, triggers, and management reports.

Exercícios da disciplina de Banco de dados, do curso de Análise e desenvolvimento de sistemas da FATEC Zona Leste

Banco de dados PL/SQL de um Super Mercado ficticio chamado SMO (SuperMarket OMCorp)

Building strong foundations in PostgreSQL.

A MySQL database for managing collegiate athletes, teams, scholarships, NIL contracts, and performance analytics using stored procedures and triggers.

A Database Management assignment focusing on a real life scenario based implementation of an SQL database. Scenario chosen was of a video game distribution service (inspirations from Steam, Epic Games, Ubisoft, etc).

End-to-end retail backend & analytics system featuring MySQL database design with automated triggers, Python workflow orchestration, and interactive Power BI executive dashboards.

Real-estate management system in PHP with MySQL and MongoDB. Four triggers and four stored procedures over listings, agents, appointments, offers and payments.

A relational database project built with SQL featuring complex queries, joins, triggers, and aggregate functions to manage music release metadata, contributors, and version history.

SQL-based Bank Transaction System using triggers, transaction validation, automatic balance updates, logging mechanisms, and table locking in MySQL.

Dairy e-commerce database system — normalized MySQL schema, triggers, atomic transactions, and OLAP analytics, driven by a Python CLI.

DBMS + SE project

Application using the PostgreSQL relational database, with SQL request, triggers and functions

Vehicle inventory control system — Node.js + Express + MySQL with SQL Triggers, file uploads via Multer

📚 Enterprise-grade Library Management System built with Python (Flask), MySQL & SQLite, featuring relational 3NF schema, ACID stored procedures, SQL triggers, automated late fines, and an interactive modern UI dashboard.

MuchMusic is a comprehensive database project for an online music service, designed to efficiently manage artists, albums, songs, customer subscriptions, playlists, and security features.