This is all one problem. DO NOT reply with just one part of an answer and for the remaining say "Chegg doesn't allow - ..."

PLEASE ANSWER EACH BULLET-POINT FOR THUMBS-UP!

Database Design, NOT A CODING QUESTION!!! Answer the following, show all of your work and provide details.

The PatientVisit relation keeps information about the patients' visits to doctors. Identify the functional dependencies in the relation. 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. Identify the functional dependency in each relation in the final relational model produced in b. Patient Visit PatientID P1209 P1209 P1215 P1221 P8912 Name Address J. Johns 134 West J. Johns 134 West J. Johns 200 West F. Brown 223 South F. Dong 45 East VisitDate DoctorID Doctor Name 3/3/02 D1256 A. Frank 9/10/02 D1256 A. Frank 3/3/02 D4523 D. Gomez 6/7/02 D6712 G. Kelly 9/12/02 D8917 M. Julius If there are multiple functional dependencies in a relation, normal- ization needs to be performed to remove those functional dependencies that do not have the primary key as the determinant(s) because those functional dependencies cause data redundancy and data anomalies. Normalization defines the first normal form (1NF), the second normal form (2NF), the third normal form (3NF), the Boyce-Codd normal form (BCNF), and so on