title: Proper way to store data in SQL
body: <p>I have basic SQL question for something I`ve done wrong. So I wish to ask what is the proper way to accomplish this.
  I have Room table. Room have room size, name and wall color. The room have furniture table, it can have many furniture. What is the right way to connect multiple furniture to room. For example:</p>
  
  <pre><code>Room Table
  roomID: 5
  size: 15
  wallColor: Blue
  haveFurniture: 2,4,5 //This is the part I`m not sure about
  
  Furniture Table
  furnitureID 2
  type: table
  color: wood
  
  Furniture Table
  furnitureID 4
  type: closet
  color: wood
  
  etc...
  </code></pre>
  
  <p>So, what is the right way to connect furniture to room. The user may create multiple rooms and multiple furniture </p>