I'm trying to store hotel data with all of it's amenities. What is the proper way of creating such a database.
Should I have a hotel table with 50-100 fields or create a relational table that stores amenities and join them later.
I can see how the relational table would save storage on hotels with no amenities but you're losing processing time by searching and joining the table.