= Advanced database developement (Triggers, views)

== Triggers:
- [wiki:Trigger1 Automatic calculation of store rating from order reviews]
- [wiki:Trigger2 Automatic update of product availability after an order]
- [wiki:Trigger3 Prevention of ordering unavailable products]
- [wiki:Trigger4 Automatic deletion of product changes when the product is deleted]
- [wiki:Trigger5 Prevention of deleting stores with existing orders or reports]
- [wiki:Trigger6 Automatic setting of the last modified date for orders]
- [wiki:Trigger7 Validation of employee authorization before making a product change]
- [wiki:Trigger8 Automatic update of employee/store statistics after an employee is hired]


== Views:
- [wiki:View1 Complete overview of products and stores]
- [wiki:View2 Complete overview of customer orders]
- [wiki:View3 Monthly sales and profit per store]
- [wiki:View4 Employee workload and salary report]
- [wiki:View5 Customer request and response overview]
- [wiki:View6 Store inventory overview]
- [wiki:View7 Customer order history]
- [wiki:View8 Store performance overview]