Is it possible to do a cascading update?

In what scenario would you want to use "set null" for updated or deleted keys? If you cannot insert a row into the table without this key being set, why are you allowed to "set null"?

Should we not just always use innoDB to ensure referential integrity?


In the album/track example, what's the real difference between ON UPDATE RESTRICT and ON DELETE RESTRICT? Like, when would "update restrict" actually matter if the album ID changed?

I am very confused about how InnoDB works. Is it a database or does it create a table?

Please explain innoDB more! What is it, I was not really sure about any of the question options.

Why can CSV files sometimes end up with the wrong number of columns when imported into a spreadsheet or database?

I think this makes sense! / I have no questions for now. I think I have a good understanding of the material covered.