HOTEL MANAGEMENT

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.Identify the entities,relationships,key attributes and other attributes.Design an ER diagram of this.

STEP 1:

Entities are:-

1.Hotel
2.Rooms
3.Cost
4.Facilities
5.Location
STEP 2:

RELATIONSHIPS:-

ab

STEP 3:

Key attribute:-

Hotel-hotel id
Rooms-Room no.
Cost-costid
Facilities-Fid
Location-pincode

STEP 4:

Other attributes:-

Hotel-name,star rate
Rooms-type
Cost-amount
Facilities-Fname
Location-street,town

STEP 5:

ER DIAGRAM

dbdhf1

Advertisements