23-04-2012, 01:25 PM
DATABASE MANAGEMENT SYSTEMS
DbmsProj.pdf (Size: 800.76 KB / Downloads: 430)
Introduction
Hotel needs to maintain the record of guests and reserve rooms beforehand.
Customers should be able to know the availability of the rooms on a particular date. They
should be able to reserve the available rooms according to their need in advance. To
make their stay comfortable, they are provided with food and other services. The record
of the food taken by each customer and the services availed by the customer should be
kept. These records help in generating bill.
Design
Entities And Attributes
1. GUEST can be of two types FAMILY and COMPANY
2. FAMILY has attributes FamilyHeadName, FamilyHeadSSN, Address, NoOfAdults,
Children. It has a weak entity MEMBERS. MEMBERS have attributes Name(Weak
key)and age.
3. COMPANY has attributes Name and Location. It has a weak entity MEMBERS
having attributes Name(Weak Key), Age, Designation.
4. ROOM has attributes RoomNo(Key), Rate, Type and Status(vacant or occupied)
5. FOOD has attributes ProductId(Key), Rate and Type.
6. BILL has attributes BillNo(Key), Date and Time.
7. FACILITIES has attributes FacilityId(Key), Type and Rate.
Relations and their description
1. GUEST are ALLOTED ROOM from CheckInDate to CheckOutDate. One
Guest(Family or Company)
can be alloted more than one room.
2. GUEST PAYS BILL. A GUEST must pay a BILL.
3. GUEST may USES FACILITIES. One GUEST can use more than one FACILITIES.
4. GUEST ORDERS FOOD at some Time on some Date. GUEST can order more than
one FOOD
item and one FOOD item can be ordered by one GUEST.
DbmsProj.pdf (Size: 800.76 KB / Downloads: 430)
Introduction
Hotel needs to maintain the record of guests and reserve rooms beforehand.
Customers should be able to know the availability of the rooms on a particular date. They
should be able to reserve the available rooms according to their need in advance. To
make their stay comfortable, they are provided with food and other services. The record
of the food taken by each customer and the services availed by the customer should be
kept. These records help in generating bill.
Design
Entities And Attributes
1. GUEST can be of two types FAMILY and COMPANY
2. FAMILY has attributes FamilyHeadName, FamilyHeadSSN, Address, NoOfAdults,
Children. It has a weak entity MEMBERS. MEMBERS have attributes Name(Weak
key)and age.
3. COMPANY has attributes Name and Location. It has a weak entity MEMBERS
having attributes Name(Weak Key), Age, Designation.
4. ROOM has attributes RoomNo(Key), Rate, Type and Status(vacant or occupied)
5. FOOD has attributes ProductId(Key), Rate and Type.
6. BILL has attributes BillNo(Key), Date and Time.
7. FACILITIES has attributes FacilityId(Key), Type and Rate.
Relations and their description
1. GUEST are ALLOTED ROOM from CheckInDate to CheckOutDate. One
Guest(Family or Company)
can be alloted more than one room.
2. GUEST PAYS BILL. A GUEST must pay a BILL.
3. GUEST may USES FACILITIES. One GUEST can use more than one FACILITIES.
4. GUEST ORDERS FOOD at some Time on some Date. GUEST can order more than
one FOOD
item and one FOOD item can be ordered by one GUEST.