VU ID: bc123456789
USERNAME: ABC
ANS:
1: Table collapsing will be applied on
the table having one to one relation ship so it will be look like this
the table having one to one relation ship so it will be look like this
i.
GUEST AND RESERVATION
GUEST AND RESERVATION
ii.
ROOM AND BILL
ROOM AND BILL
2: Pre-joining will be applied on table having
one to many relationship so it will look like this
one to many relationship so it will look like this
i.
RESERVATION
RESERVATION
ii.
ROOM
ROOM
Guest/Reservation
|
Guest ID
|
Name
|
Address
|
Contact No
|
Reservatio No
|
Check Date
|
Check Time
|
Check out Date
|
Check out Time
|
Room/Bill
|
Room
Type |
Availability
Status |
Bill
ID |
Room
Charges |
Service
Charges |
Total
charges |
Room/Reservation
|
Room ID
|
Room Type
|
Availability Status
|
Reservation No
|
Check date
|
Check time
|
Out date
|
Out time
|