A. Consider the following relation R with all functional dependences F and normalize it into 2NF, 3NF, and BCNF. R= {Patient_No,Patient_Name,App_No,Time,Doctor} F= { Patient_No Patient_Name Patient_No, App_No Time, Doctor Time App_No }

B. Explain why the following relation R is in 3NF but not in BCNF. R={a,b,c,d} F= {a,b c,d a,d b}