title: ERROR 1826: Duplicate foreign key constraint name
body: <p>thank you for your time.
  I am trying to build a database with with the following instructions</p>
  <p>T1-Hotel (<strong>hotelNo</strong>, hotelName, city)
  T2-Room (<strong>roomNo</strong>, hotelNo, type, price)
  T3-Guest (<strong>guestNo</strong>, guestName, guestAddress)
  T4-Booking (<strong>hotelNo</strong>, <strong>guestNo</strong>, <strong>dateFrom</strong>, dateTo, roomNo)</p>
  <p>I get a Constraint duplication error but I cant tell there is a duplication in the schema.</p>
  <pre><code>CREATE TABLE `hotel_booking`.`Booking` (
      `hotelNo` VARCHAR(5) NOT NULL,
      `guestNo` VARCHAR(5) NOT NULL,
      `datefFrom` DATE NOT NULL,
      `dateTo` DATE NULL,
      `roomNo` VARCHAR(5) NULL,
      PRIMARY KEY (`hotelNo`, `guestNo`, `datefFrom`),
      INDEX `guestNo_idx` (`guestNo` ASC) VISIBLE,
      INDEX `roomNo_idx` (`roomNo` ASC) VISIBLE,
      CONSTRAINT `hotelNo`
          FOREIGN KEY (`hotelNo`)
          REFERENCES `hotel_booking`.`Hotel` (`hotelNo`)
          ON DELETE NO ACTION
          ON UPDATE NO ACTION,
      CONSTRAINT `guestNo`
          FOREIGN KEY (`guestNo`)
          REFERENCES `hotel_booking`.`Guest` (`guestNo`)
          ON DELETE NO ACTION
          ON UPDATE NO ACTION,
      CONSTRAINT `roomNo`
          FOREIGN KEY (`roomNo`)
          REFERENCES `hotel_booking`.`Room` (`roonNo`)
          ON DELETE NO ACTION
          ON UPDATE NO ACTION);
  </code></pre>
  <p>I get the following error ERROR 1826: Duplicate foreign key constraint name 'hotelNo'
  What is wrong and how it can be corrected?<a href="https://i.stack.imgur.com/7ciVu.png" rel="noreferrer"><img src="https://i.stack.imgur.com/7ciVu.png" alt="Columns and keys" /></a></p>
  <p><a href="https://i.stack.imgur.com/sEo0B.png" rel="noreferrer"><img src="https://i.stack.imgur.com/sEo0B.png" alt="foreign keys" /></a></p>