A table that always has a one-to-many relationship with a relationship table.
A)append query
B)delete query
C)M:N
D)primary table
E)1:M
F)update query
G)action query
H)1:1
I)expression
J)history table

Question

Quizplus · Accepted Answer

Primary table refers to the table on the one side of a one-to-many relationship, which always has a one-to-many relationship with a relationship table. This table contains the primary key which is being referenced by the other table(s) in the relationship.

Answer: E
 A one-to-many relationship means that one record in the primary table corresponds to one or more records in the related table. This is denoted by the 1:M relationship type.

Answer: J
 A history table is used to keep track of changes made to the data in a primary or related table. It is often used in conjunction with an action or update query to keep a record of the changes made. It has a one-to-many relationship with the table it is tracking, as multiple changes can be made to the same record over time.

A Table That Always Has a One-To-Many Relationship with a Relationship