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
i.
GUEST AND RESERVATION
ii.
ROOM AND BILL
2: Pre-joining will be applied on table having
one to many relationship so it will look like this
i.
RESERVATION
ii.
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
|
Post a Comment
Don't Forget To Join My FB Group VU Vicky
THANK YOU :)