What are the four primary "integrity" types we care about?
Say you want to make sure that the values in an integer column are always greater than 0. What specific kind of constraint would you use, and is this an example of domain integrity or entity integrity?
What is the difference between a foreign key and a foreign key constraint?
Only recently has SQLite provided foreign key constraints. If you had an application that used an older version of SQLite, yet you still wanted to maintain domain integrity of all foreign key values. What do you think your program would have to do when, say, deleting a music ALBUM and a TRACK record has the FK album_id? Below is an illustration of some data in the two tables for those entities.