Assuming the choice is to stay with relational model, how are tables structured in the case of large User profiles? All the examples I see consider only simple cases, such as a "profile" containing name, email, and a few other columns.
Say the app is a Life Dashboard, where each user profile has all kinds of disparate data, from favorite movies, to money spending statistics, to pictures. And since its a dash, we want to return all of it to the single page app upon user login.
Is this a use case for denormalization? without denormalization, it would require multiple queries just to return the first request: an authorization query, followed by one for each of the potentially 10-15 different normalized tables on userID. is this common? or in this case is denormalization or even switching to NoSql the preferred method? or case by case depending on how whether we want each entity in the normalized table represented and queryable?