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.

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

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.

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

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

Building strong foundations in PostgreSQL.

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

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).

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

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

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.

DBMS + SE project

This repository (in spanish language) contains study material, codes, and exercises in the Databases Laboratory course taught at UCSC in the 2024-1 semester.

A set of SQL problem-solving tasks

Sales Intelligence Hub is a branch-based sales and financial tracking system built using Python, MySQL, SQL Triggers, and Streamlit. It automates payment tracking, pending calculations, branch analytics, and role-based access control through a professional business intelligence dashboard.