Advanced database developement (Triggers, views)

Triggers:

• Automatic calculation of store rating from order reviews
• Automatic update of product availability after an order
• Prevention of ordering unavailable products
• Automatic deletion of product changes when the product is deleted
• Prevention of deleting stores with existing orders or reports
• Automatic setting of the last modified date for orders
• Validation of employee authorization before making a product change
• Automatic update of employee/store statistics after an employee is hired

Views:

• Complete overview of products and stores
• Complete overview of customer orders
• Monthly sales and profit per store
• Employee workload and salary report
• Customer request and response overview
• Store inventory overview
• Customer order history
• Store performance overview