I'm creating a charter database structure. I'm trying to figure something out, I have read on here that databases should be normalized. Now, I'm a bit confused on this because I believe I have stumbled across database tables that have multiple items in a single column. What I mean by this is, let's say the db creator is creating a column, the column name is IP Address. Now within that column there's a list of ip addresses separated by semi-colons, is this the correct way to do this?
My scenario is this, I'm creating a list of items, each item is going to be a list of "amenities". Should I create a separate table and link it? Or should I be just having the list of amenities separated by a delimiter?