An Introdution to SQLite

http://www.youtube.com/watch?v=f428dSRkTs4&NR=1
Richard Hipp, author of SQLite talks about its features and using it, as opposed to other variants of SQL.
This is a Google video, recorded in 2006. Mildly Interesting.

Since then, SQLite has implemented support for Foreign Keys.
http://www.sqlite.org/foreignkeys.html#fk_actions

However, I believe Android below 2.2, runs a version of SQLite that doesn’t support this feature, and even in Android 2.2 and above, the feature is turned off by default.
http://stackoverflow.com/questions/2545558/foreign-key-constraints-in-android-using-sqlite-on-delete-cascade/3404279#3404279

http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers

Evidentally, the way to use simulated foreign keys in Android, apparantly has to do with
TRIGGERS, or ..
here are a few pages that might be useful later:

Referential integrity with sqlite on Android the lazy way

For future reference:

 http://mobile.tutsplus.com/tutorials/android/android-sqlite/

http://www.sqlite.org/docs.html