Identify the entities, relationships, key attributes and other attributes and then design the ER diagram: There are many hotels in a country. Each hotel is identified by its id, name and star rate....

1. Identify the entities, relationships, key attributes and other attributes and then design the ER diagram:

There are many hotels in a country. Each hotel is identified by its id, name and star rate. Each hotel provides many rooms. Rooms are identified by Room no. and type. Each room is rented for a cost. Cost is identified by its id and amount. A hotel has many facilities available with it. Facilities are identified by its id and name. A hotel is located at a particular location. Location is identified by street, town and pincode.