Which of the following table names would appear in Design view to indicate a table being used in a self-join relationship and distinguish it from the first instance of the table in the relationship?
A)1_tblPatient
B)tblPatient2
C)tblPatient_1
D)1tblPatient

Question

Quizplus · Accepted Answer

Using "tblPatient_1" indicates that the table is a duplicate of "tblPatient" and is being used in a self-join relationship. Adding the underscore and number makes it clear that it is a separate entity and distinguishes it from the first instance of the table. Option A and D are not recommended as they do not follow naming conventions and may cause issues with querying the table. Option B could be confusing as it does not explicitly indicate that it is a duplicate table.

Which of the Following Table Names Would Appear in Design