CUSTOMERS

The database contains the following information about each of the customers: name, surname, gender, customer identification number, age, phone number, e-mail, home address.

EMPLOYEE

The database keeps the following information about each of the employee: employee identification number, name, surname, employee department, e-mail, salary, age, gender.

HOTEL

The database contains the following information about the hotels: hotel name, hotel registration number, number of star,concept, address, phone number, e-mail, hotel type.

ROOMS

The database contains the following information about the rooms: room identification number, room type,features of room, room floor, number of beds, number of person.

SERVICES

The database contains the following information about the services: service type, price.

PAYMENT

The database contains the following information about the hotels: account, method, price. BOOKING

The database contains the following information about the booking: reservation identification number, check-in, check-out.

Hi, these are the necessary entities and attributes of our ER diagram which needs to be drawn according to these given attributes and also we need the REQUIREMENTS of the ER diagram. So we need the ER diagram and also the requirements. Thank you.