| | 1 | = Advanced database developement (Triggers, views) |
| | 2 | |
| | 3 | == Triggers: |
| | 4 | - [wiki:Trigger1 Automatic calculation of store rating from order reviews] |
| | 5 | - [wiki:Trigger2 Automatic update of product availability after an order] |
| | 6 | - [wiki:Trigger3 Prevention of ordering unavailable products] |
| | 7 | - [wiki:Trigger4 Automatic deletion of product changes when the product is deleted] |
| | 8 | - [wiki:Trigger5 Prevention of deleting stores with existing orders or reports] |
| | 9 | - [wiki:Trigger6 Automatic setting of the last modified date for orders] |
| | 10 | - [wiki:Trigger7 Validation of employee authorization before making a product change] |
| | 11 | - [wiki:Trigger8 Automatic update of employee/store statistics after an employee is hired] |
| | 12 | |
| | 13 | |
| | 14 | == Views: |
| | 15 | - [wiki:View1 Complete overview of products and stores] |
| | 16 | - [wiki:View2 Complete overview of customer orders] |
| | 17 | - [wiki:View3 Monthly sales and profit per store] |
| | 18 | - [wiki:View4 Employee workload and salary report] |
| | 19 | - [wiki:View5 Customer request and response overview] |
| | 20 | - [wiki:View6 Store inventory overview] |
| | 21 | - [wiki:View7 Customer order history] |
| | 22 | - [wiki:View8 Store performance overview] |
