title: Entity Relationship Diagram for Hotel
body: <p>I need to create an ERD for a hotel, the question reads as follows:</p>
  
  <p>"<em>The owner of a set of hotels would like to have a hotel management system built for his or 
  her hotels. The hotels are located in major cities and tourist attraction areas of South 
  Africa. In each hotel, employees are hired to perform various duties. In each hotel, guests 
  make reservations for rooms of their choice, and they are billed according to the type of 
  room they have reserved. 
  Given the business scenario above, please draw an entity relationship diagram indicating all entities and relationships (cardinality).</em> "</p>
  
  <p>This is what I have created:</p>
  
  <p><img src="https://i.stack.imgur.com/czp4w.gif" alt="enter image description here"></p>
  
  <p><strong>My Questions</strong></p>
  
  <ul>
  <li><p>if Employee_ID is a foreign_key in Hotel, will it be a foreign_key in Employees table aswell or does it just change to a Primary key?</p></li>
  <li><p>Is it correct / okay to add Hotel_code, and Room_ID in the Reservation table? Is Hotel_CODE a foreign key in RESERVATION table?</p></li>
  <li><p>Is the overall design of the ERD correct or to an acceptable level including keys and attributes</p></li>
  </ul>
  
  <p>If someone could skim this over for me it would be much appreciated</p>