title: Database design for multiple hotel and multiple room?
body: <p>Suppose that I:</p>
  
  <ol>
  <li>Own multiple hotels (say, 3)</li>
  <li>Want to make a database about the rooms in those hotels.</li>
  </ol>
  
  <p>So I have two tables in my database: hotels and rooms.</p>
  
  <p>This the <strong>hotel table</strong>: (Owner #1 is me)</p>
  
  <pre><code>Hotel_ID(primary) | Hotel_Name | Owner_ID | Star |Phone | Info |
   1                     Java          1       3      ..     ..
   2                    Borobudur      1       5      ..     ..
   3                     Asia          1       1      ..     .. 
   4                    Wijaya         2       3      ..     ..
  </code></pre>
  
  <p>Thus, the <strong>room table</strong>, (I presume) will become like this:</p>
  
  <pre><code>Hotel_ID | Room_Number | Capacity |   Status   | Price_perNight |
      1         1             4         Vacant           5 
      1         2             4         Vacant           5  
      1         3             3        Occupied          4
      2         1             4         Vacant           4
      2         2             4        Occupied          4
      3         1             3        Occupied          1
      ..        ..           ..           ..             ..
  </code></pre>
  
  <p>Q:
  1. Is this approach valid? (room table doesn't have any primary key, and doesn't need any)</p>
  
  <ol start="2">
  <li>Is there any better design?</li>
  </ol>
  
  <p>Thanks in advance.</p>