Database normalization
This gave me a headache a few years ago when I tried to move over to Room. I thought it was too convoluted to do complex relationship with the library. But now that I know how to do it using Room, it needs to be done.
Current database structure is unnormalized. I just winged it with a JSON to store multiple language options. This held back the potential of this database.
To normalize it to 3NF, a new table 'EpisodeLanguage' will be created. This table uses a composite key of both episode and language ID to create a many-to-many relationship between them.