Knowing that one reservation can book more than one room and one room may be booked by more than one reservation, at different times, and the same room may have different prices in different reservations, analyze the given schema: ResRoom = (Res No, Deadline, State, {Room.id}, price, type) (i) {20 points} Draw all functional dependencies (fds) (ii) {5 points} Create a meaningful snapshot by populating the table ResRoom with, at least, 5 rows (iii) {5+5+5 points} Discuss insertion, deletion and modification anomalies (iv) {10 points} Is ResRoom in 1NF? If yes WHY3? If not modify ResRoom so as to put it in 1NF. Let us call ResRoomla and ResRoomlb the (only) 2 relations resulting out of this step (v) {10 points} Draw the fds of ResRoomla and ResRoomlb (vi) {25 points} Are ResRoomla and ResRoomlb in 2NF? If yes WHY?? If not modify them so as to put it in 2NF. Let us call ResRoom2a and ResRoom2b the new relations, i.e. the relation resulting out of this step (vii) {10 points} Draw the fds of ResRoom2a and ResRoom2b (viii) {5 points} Are ResRoom2a and ResRoom2b in 3NF? If yes WHY?? If not, modify them so as to put them in 3NF