Case 19-3 Linda Has Recently Started Her Job as a Nursing

Multiple Choice

Case 19-3 Linda has recently started her job as a nursing supervisor at Hankons Cancer Treatment Centre. As part of the job, she has to look into the database of all the currently admitted patients and their ongoing treatment status.
Linda uses forms in Microsoft Access 2016 to display data from two or more related tables at the same time. This offers a complete picture of the information in the patient database. If Linda has to create a form based on two tables labeled Patient Identity and Patient Illness, the two tables should have _____.

A) a defined relationship
B) a secondary table within the primary table
C) matching data entries
D) unique records that are not used in any other table