ER DIAGRAM because that DRIVING LICENSE(ROLL NO.17 S5 CS2)MAPPING E-R to RELATIONAL model (ROLL NO:35 ,S5CS2)


ER chart OF HOTEL MANAGEMENT(ROLL NO.14S5CS2)

September 22, 2013

poojakrishnajSimple ER diagramsLeave a comment


HOTEL MANAGEMENT

There are countless hotels in a country.Each hotel is figured out by that id,name and also star rate.Each hotel provides many rooms.Rooms are figured out by Room no. And also type.Each room is rented because that a cost.Cost is determined by that id and also amount.A hotel has plenty of facilities available with it.Facilities are figured out by that id and name.A hotel is situated at a certain location.Location is established by street,town and also pincode.Identify the entities,relationships,key attributes and also other attributes.Design an er diagram of this.

You are watching: Er diagram for hotel management system

STEP 1:

Entities are:-

1.Hotel2.Rooms3.Cost4.Facilities5.LocationSTEP 2:

RELATIONSHIPS:-

STEP 3:

Key attribute:-

Hotel-hotel idRooms-Room no.Cost-costidFacilities-FidLocation-pincode

STEP 4:

Other attributes:-

Hotel-name,star rateRooms-typeCost-amountFacilities-FnameLocation-street,town

STEP 5:

ER DIAGRAM


Rate this:


Share this:


Like this:


Like Loading...

Related


Leave a reply Cancel reply


Enter your comment here...

Fill in her details below or click an symbol to log in in:


*

Email (required) (Address never ever made public)
Name (required)
Website
*

You are commenting utilizing your historicsweetsballroom.com.com account.(LogOut/Change)


*

You are commenting using your Google account.(LogOut/Change)


*

You room commenting making use of your Twitter account.(LogOut/Change)


*

You are commenting utilizing your on facebook account.(LogOut/Change)


Cancel

Connecting come %s


educate me of brand-new comments via email.

inform me of brand-new posts via email.


Δ


ER DIAGRAM because that DRIVING LICENSE(ROLL NO.17 S5 CS2)MAPPING E-R come RELATIONAL model (ROLL NO:35 ,S5CS2)


Recent Posts
Archives
Categories
Meta

Create a free website or blog at historicsweetsballroom.com.com.


FollowFollowing
Join 44 other followers
Sign me up
Loading Comments...

See more: What Does Equis Mean In English Recipes, What Is The Meaning Of Equis


Write a Comment...
Email (Required)Name (Required)Website
Privacy & Cookies: This site offers cookies. By proceeding to usage this website, you agree to your use. To discover out more, including exactly how to regulate cookies, view here:Cookie policy
%d bloggers prefer this: