Multiple Choice Quiz App with SQLite Integration Part 11 - CATEGORIES - Android Studio Tutorial

In part 11 of the SQLite quiz tutorial, we will start implementing categories into our quiz. For this we will create another table in our SQLite database that will contain all the categories with a name and id column. We will then connect our questions table to this category table by adding a category_id column, which references a corresponding id in the categories table as a foreign key. This way we can not add any rows to our questions child table, that have a category id that doesn't also exist in the categories parent table.
By adding "ON DELETE CASCADE" to the schema of our question table, SQLite will automatically delete all questions for a certain category, if we delete the category itself.
We enable foreign key constraints in the onConfigure callback of our SQLiteOpenhelper class, by setting setForeignKeyConstraintsEnabled to true.
After creating our new database schema, we will download the database from Android Studio's Device File Explorer and open it in "DB Browser for SQLite". If everything worked correctly, questions with an invalid category id should have not been inserted into the database.

Watch the whole playlist:
https://www.youtube.com/playlist?list=PLrnPJCHvNZuDCyg4Usq2gHMzz6_CiyQO7

Example code for this part:
https://gist.github.com/codinginflow/0de901b51abf85bc16cc82a806408b63

____________________
? Find the BEST programming tutorials on TutHub:
https://tuthub.io

⭐ Get my MVVM Caching Course now:
https://codinginflow.com/caching

❗ Subscribe to the channel:
https://www.youtube.com/c/codinginflo...

? Subscribe to the Coding in Flow newsletter:
https://codinginflow.com/newsletter

❓ Join our free developer community:
https://discord.gg/TSnMvmc

? Follow Coding in Flow on other sites:
Facebook: https://www.facebook.com/codinginflow
Instagram: https://www.instagram.com/codinginflow
TikTok: https://www.tiktok.com/@codinginflow
Twitter: https://twitter.com/codinginflow
Github: https://github.com/codinginflow

? Business requests, sponsoring, etc.: [email protected]