Can you help me to normalize Online Hotel Reservation System. In the database I will store information about the hotels (name, city, country, number of stars, room prices, total number of double rooms, total number of single rooms, number of available rooms, etc); customers (name, email, telephone, address, username, password, etc); reservations (username of the customer who made the reservation, Hotel ID, date of arrival, date of departure, total cost, and etc.).
My Idea:
############
Table Customer:
CustomerID
First Name
Last Name
Gender
Address
Phone
Mail
##############
Table Hotels
HotelID
Name
Address
City
Phone
Number of Stars
###############
Reservation Table
ReservationID
CustomerID
HotelID
Reservation Date
Arrival Date
Departure Date
RoomCategoryID
Status
TotalCost
###############
Table Room Categories
Category ID
Category Name
Number of beds
################
Table Rooms
HotelID
Room Number
Category ID
################
Table Room Price
HotelID
Category ID
Season
Duration
Room Price
################
