crate a hotel management python project using mysql

def create_hotel():
  # create a 'hotel' database
  # create a 'rooms' table, with 'room_number', 'room_type', 'price' columns
  # create a 'guests' table, with 'guest_name', 'room_number'
  # create a 'bookings' table, with 'guest_name', 'room_number', 'check_in_date', 'check_out_date' columns
  # insert at least 3 guests into the 'guests' table
  # insert at least 3 bookings into the 'bookings' table
  pass