Changeset 62b2964 for database/Advanced Database Developement

Timestamp:

09/16/26 05:27:23 (2 weeks ago)

Author:

Klimentina Efremova <klimentina08642@…>

Branches:

finki-main, main

Children:

33517cc

Parents:

81bc7da

Message:

Project Handcraft Marketplace

Location:

database/Advanced Database Developement

Files:

• Triggers/Automatic calculation of store rating from order reviews.txt (added)
• Triggers/Automatic deletion of product changes when the product is deleted.txt (added)
• Triggers/Automatic setting of the last modified date for orders.txt (added)
• Triggers/Automatic update of employee-store statistics after an employee is hired.txt (added)
• Triggers/Automatic update of product availability after an order.txt (added)
• Triggers/Prevention of deleting stores with existing orders or reports.txt (added)
• Triggers/Prevention of ordering unavailable products.txt (added)
• Triggers/Validation of employee authorization before making a product change.txt (added)
• Views/Complete overview of customer orders.txt (added)
• Views/Complete overview of products and stores.txt (added)
• Views/Customer order history.txt (added)
• Views/Customer request and response overview.txt (added)
• Views/Employee workload and salary report.txt (added)
• Views/Monthly sales and profit per store.txt (added)
• Views/Store inventory overview.txt (added)
• Views/Store performance overview.txt (added)