Virtual Tech Gaming Store

This site demonstrates real form submissions into a MySQL database, trigger-enforced rules, stored procedure operations, and live reporting queries for a capstone project.

Place a Test Order Database Design View Reports Stored Procedures

Order Form: demonstrates 3 triggers (oversell prevention, inventory auto-decrease, one default address per customer).

Stored Procedures: demonstrates 4 procedures (restock, sales report, update order status, low inventory list).

Database

MySQL / InnoDB

Tables

Customer, Address, Product, Inventory, Orders, OrderItem, Payment

What this proves

Foreign keys enforce correct relationships
Triggers enforce business rules automatically during inserts/updates
Stored procedures centralize operational tasks using reusable CALL commands
Reports pull real data with joins + totals

Quick start

Place an order (triggers run automatically)
Run stored procedures (restock / status updates / sales totals)
Open Reports

Group Project By:

Rickeria Lendale
Soraya Prada
Elizabeth Ruiz