How many relational tables are necessary to implement your model for Dr. Franklin's clinic? \begin{tabular}{|l|} \hline 2 \\ \hline 3 \\ \hline 4 \\ \hline 5 \\ \hline \end{tabular} Which of the following is the best way to implement the association between TESTS and PATIENT VISITS tables? Post the primary key of PATIENT VISITS in TESTS as a foreign key. Post the primary key of TESTS in PATIENT VISITS as a foreign key. Create a linking table between TESTS and PATIENT VISITS with a primary key that combines the primary keys of TESTS and PATIENT VISITS. Create a new table that includes the primary keys of TESTS and PATIENT VISITS as foreign keys. None of these is the best option. Which of the following is the best way to implement the association between PATIENTS and PATIENT VISITS tables? Post the primary key of PATIENT VISITS in PATIENTS as a foreign key. Post the primary key of PATIENTS in PATIENT VISITS as a foreign key. Create a linking table between PATIENTS and PATIENT VISITS with a primary key that combines the primary keys of PATIENTS and PATIENT VISITS. Create a new table that includes the primary keys of PATIENTS and PATIENT VISITS as foreign keys. None of these is the best option. Write out a set of relational tables that correspond to the class diagram that you prepared for Problem 1. Identify primary and foreign keys. Using Microsoft Access, define the tables and set up the relationships corresponding to your diagram. Then answer questions 1 to 6 below based on your tables