loading...

CS614 Assignment 1 Solution Fall 2018

Question:                                                                                                                                                                           

Consider the following part of an ERD of Hotel Reservation System.

Table Collapsing and Pre-Joining are two important techniques of de-normalization. You are required to perform following tasks:

Task 1: Identify all such relations from above given ERD on which Table Collapsing technique can be applied. After that apply table collapsing techniques on tables having such relationships.

Ans 1:  Table collapsing will be applied on the table having one to one relation ship so it will be look like this

  1.                         GUEST   AND RESERVATION
  2.                         ROOM AND BILL

 

Task 2: Identify all such relations from above given ERD on which Pre-joining technique can be applied. After that apply table collapsing techniques on tables having such relationships.

Ans: 2:    Pre-joining will be applied on table having one to many relationship so it will look like this

 

DOWNLOAD SOLUTION HERE
loading...