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


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

September 22, 2013

poojakrishnajSimple ER diagramsLeave a comment


HOTEL MANAGEMENT

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

You are watching: Er diagram of 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 answer Cancel reply


Enter her comment here...

Fill in your details below or click an icon to log in:


*

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

You are commenting using your usmam.org.com account.(LogOut/Change)


*

You room commenting utilizing your Google account.(LogOut/Change)


*

You room commenting utilizing your Twitter account.(LogOut/Change)


*

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


Cancel

Connecting come %s


inform me of new comments via email.

inform me of brand-new posts via email.


Δ


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


Recent Posts
Archives
Categories
Meta

Blog in ~ usmam.org.com.


Loading Comments...

See more: How To Get The Spear In Mario Kart Wii ? How To Unlock Spear In Mario Kart Wii


Write a Comment...
Email (Required)Name (Required)Website
Privacy & Cookies: This site provides cookies. By continuing to usage this website, friend agree to your use. To uncover out more, including exactly how to control cookies, check out here:Cookie plan
%d bloggers prefer this: