TOPIC

Collect one example for Mapping of ER Model to Relational Model

HOTEL MANAGEMENT

 ER Diagram of a Hotel Management is given below. Hotel is identified by it’s id,name and star rate. Hotel provides rooms.Rooms are identified by Room number and type. The cost details and facilities available are listed. The location of the hotel is also mentioned.

dbdhf1

MAPPING OF ER DIAGRAM TO RELATIONAL MODEL

 

ENTITIES

HOTEL

 

Hotelid name Star rate
     

ROOMS

 

 

Roomno Type
   

 

LOCATION

Pincode Street Town
     

 

 

FACILITIES

Fid Fname
   

 

COST

 

Costid Amount
   

 

RELATIONSHIPS

 

HAS

 

Hotelid Roomno
   

HAS

 

Hotelid Fid
   

 

LOCATED AT

Hotelid Pincode Since
     

 

RENTED AT

 

Roomno Costid
   

 

 

Thus the ER Model is mapped to Relational Model.

 

Advertisements