CS614 Assignment No 1 solution and discussion

Cs614 Assignment no 1 Solution and Discussion 

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.

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.

Note: Deadline for assignment submission is 22 November 2018.

Please Discuss About Topic If you Know.