9. Transform the following E-R model to a relational model ChargeID Amount ReservationNo ( Check-InTime Check-OutTime ymentMethod Charges FinalBillAmount PhoneName Address Customer Make Reservation Assig Room RoomNo Type Size View Smokin Floor Price 10. The PatientVisit relation keeps information about the patients' visits to doctors. a. Identify the functional dependencies in the relation. b. Is this relation in 2NF, 3NF, and BCNF, and why? If not, show your steps of performing the normalization to transform the relation into 2NF, 3NF, and BCNF. Show all referential integrity constraints in the relational model that result from the normalization