CS614 Assignment 1 solution fall 2018
CS614 Assignment 1 solution fall 2018

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

Facebook
Twitter
LinkedIn
WhatsApp

Leave a Reply

Your email address will not be published. Required fields are marked *