title: How to Add room categories for a particular hotel
body: <p>I am creating a hotel master where i've these tables :</p>
  
  <pre><code>tbl_hotel_type : id,type_name,type_code and more
  tbl_hotel : id,name,code and more
  tbl_hotel_info : id,hotel_id,hotel_type_id and more
  tbl_room_categories : id,hotel_type,room_catname,room_catcode and more
  </code></pre>
  
  <p>Now i want to relate which hotel has which room categories i.e.</p>
  
  <p>1.Should i add another column in "tbl_hotel_info" as "room_categories" that will contain ids of all room categories in single column in particular row of "tbl_hotel_info" for a particulat hotel info.  </p>
  
  <ol start="2">
  <li>Or should,I create a new column in "tbl_room_categories" as "hotel_ids" that will contain all ids of hotel belongs to this particular room_category row.</li>
  </ol>
  
  <p>Or both approaches are wrong and, I've to do something else please suggest me a better way to achieve this . Thanx. </p>