理解FOREIGN KEY / CASCADE约束的问题

I need some help at understanding how foreign keys and cascades work. I understood the theory but I'm having troubles to apply these to a real world example.I need some help at understanding how foreign k