Re: Sakila DB Question

[Peter Brawley]

> if I update the actor table or the film table
> it would cascade down to the table which bridges them both?

You have misunderstood foreign keys. They do not create new data.

If you update a key value in film or actor, CASCADE forces propagation of your update to those key values which exist in tables with such a declared FK.

Your film_actor table does not have a row with matching key values until you insert it in that table.