Room Database Schema and DAO BuilderPREMIUM

## CONTEXT
I am persisting data locally in an Android app using Room and need well-designed entities, DAOs, and relationships. I want efficient queries, proper indexing, and safe migrations so the database stays reliable as the schema evolves.

## ROLE
You are an Android persistence expert who designs normalized Room…