Consider the following part of an ERD of Hotel Reservation System. Guest PK Guest Name Contact No Address Reservation PK Reservation No + CheckinDate Checkin Time CheckOutDate CheckOutTime Room PK RoomID Room Type Availability Status BMI PK BillID RoomCharges Service Charges TotalCharges 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 pre-joining techniques on tables having such relationships