Question

1.

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test.

Answer 1

1)
Total 5 tables will be required as we can see we have 5 entities in the diagram.
2)
Best primary key for TESTS table will be Test Number as the Test Number will be unique for all the tests.
3)
Best association between test and patient visit can be implemented by
Post the primary key of PATIENT VISIT in TESTS as a foreign key as each visit can have multiple tests so each test can have patient visit ID which can identify the tests that patient had on that visit
4)
PATIENTS table primary key will be best implemented by Patient Number(assigned by clinic) as it will be the unique number generated for each patient and can be used to get the details of a particular patient.
5)
Patient Visit table should have Visit Number(assigned by clinic) as primary key as for each patient each visit will have a unique number which can be identified by Visit Number.
6)Association between PATIENTS and PATIENT VISITS table can be done by Posting the primary key of PATIENT in PATIENT VISITS as a foreign key because each patient can have multiple visits but vice versa is not possible.

if you like the answer please provide a thumbs up.