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

In the rgb model, which color is formed by combining the constituent colors? a) black b) brown c) yellow d) white e) blue

In a home that has 120 v service, there is an electric appliance that has a resistance of 12 ohms. how much power will this appliance consume? a. 10 w b. 120 w c 1200 w d. 1440 w

Anew author is in the process of negotiating a contract for a new romance novel. the publisher is offering three options. in the first option, the author is paid $5,000 upon delivery of the final manuscript and $20,000 when the novel is published. in the second option, the author is paid 12.5% of the net price of the novel for each copy of the novel sold. in the third option, the author is paid 10% of the net price for the first 4,000 copies sold, and 14% of the net price for the copies sold over 4,000. the author has some idea about the number of copies that will be sold and would like to have an estimate of the royal- ties generated under each option. write a program that prompts the author to enter the net price of each copy of the novel and the estimated number of copies that will be sold. the program then outputs he royalties under each option and the best option the author could choose. (use appropriate named constants to store the special values such as royalty rates and fixed royalties.