Please help me with Accounting Information system question

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. Required: 1. How many relational tables are necessary to implement your model for Dr. Franklin's clinic? 2. Which of the following is the best primary key for the TESTS table? 3. Which of the following is the best way to implement the association between TESTS and PATIENT VISITS tables? 4. Which of the following is the best option for the PATIENTS table primary key? 5. Which of the following is the best option for the PATIENT VISITS table primary key? 6. Which of the following is the best way to implement the association between PATIENTS and PATIENT VISITS tables? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 :Which of the following is the best primary key for the TESTS table? i. . . Test number Test date Test price Test descriptionComplete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 :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. OPost 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. ONone of these is the best option. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Which of the following is the best option for the PATIENTS table primary key? OPatient phone number Patient number (assigned by clinic) Patient name Patient name ONone of these is a good optionComplete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 :Which of the following is the best option for the PATIENT VISITS table primary key? Patient number Visit date Visit number (assigned by clinic) Visit description ONone of these is a good option