Drawing Entity Relationship Diagram (ERD) :

local hotel needs a system that keeps track of its bookings (future, current and archived), rooms and guests. A room can be of a particular type and a particular price band. Room prices vary from a room to a room (depending on its type, lists of facilities, etc.).

A room booking can include more than one room and more than one customer

.A Customer can make one or many Bookings. Each customer is identified by a unique customer id. The hotel stores each customer first name, last name, the country, city, street where customer lives. Also,the hotel stores a one or more mobile number for each customer if exist.

Each booking is identified by a unique id. A hotel keeps track of the customer's the start, end date of booking and total payment due amount. A payment number identify a particular payment for a specific booking. The date and amount are recorders for each payment. A Booking can be for one or many Guests -the Guest is not necessarily the person who makes the Booking.

A Room is identified by unique id. The database must store the floor of each room. A Room can be on one or many Bookings. A Room may have many different Room Facilities