1 Answer - Sort by: Date | Rating
first begin to analysis the er diagram for the hotel:
then start to think about the type of system u want to chose the entities
er diagram can be for management system or reservation system or .....
if reservation system the hotel will have 3 basic tables and you can add more .....
1- guests = pasportno + tel + email + .....
2- room = roomno + size + cost + .....
3- reservation = Reserveno + check in + check out + total cost + .....
and you can add more entities like facilities ,..........
finally start to analysis the relationship between entities
1- (guest - reserve) (1 - m )
guest can have many reserve but reserve no back to one guest
2- (reserve - room) (1 - m)
reserve can have more than one room but the room back to one reserve
by adding more entities you can add more relation between entities
hope that will help you in your problem
then start to think about the type of system u want to chose the entities
er diagram can be for management system or reservation system or .....
if reservation system the hotel will have 3 basic tables and you can add more .....
1- guests = pasportno + tel + email + .....
2- room = roomno + size + cost + .....
3- reservation = Reserveno + check in + check out + total cost + .....
and you can add more entities like facilities ,..........
finally start to analysis the relationship between entities
1- (guest - reserve) (1 - m )
guest can have many reserve but reserve no back to one guest
2- (reserve - room) (1 - m)
reserve can have more than one room but the room back to one reserve
by adding more entities you can add more relation between entities
hope that will help you in your problem
0
0
- How Does Understanding OSI Help Us Troubleshoot Networks?
- What Is The Risk Factor Associated When The Power Cables Are Twisted And Winded Up Tightly?
- What Transmission Media Is Able To Transmit Data The Fastest?
- Is There Ant Social Networking Sites For People That Are 12?
- Explain Data Transmission Media In Detail?
- What Is Meant By Network?
- Factors To Be Considered When Connecting Network?
- What Are The Steps For Setup Pear To Pear Network?
- What Is Logical Network Topology?
- When To Use Striaght-through?
- What Is Instances And Scheme?
- What Holds Sponge Layers Together?
- What Is Data Communication And Networking?
- Which Layer Is Plastic-like?
- How Is A Social Network Different From A Group?
- What's My Default Router Number?
- How To Set Up A CAN Network?
- How Can I Get Connected To Storm Thru Net And In English?
- What Is Local Mapping Transparency?
- 1. Why Are The Sales And HR Servers Connected To The Network At The Access Layer?
- What Is The Madrid Protocol?
- How Do You Connect A MicroSD Adapter To Your Computer?
- What Is Network Architecture?
- What Is Half Duplex Characteristics?
- What Us Half Duplex Characteristics?

New Comment - Comments are editable for 5 min.