Appian Associate Developer (ACD100) — Question 10

A client asks you to store work location information for their employees. The client mentions that multiple employees may be assigned to multiple work locations.
Which type of database relationship is the client describing?

Answer options

• A. One-to-Many (1:N)
• B. Many-to-One (N:1)
• C. Many-to-Many (M:N)
• D. One-to-One (1:1)

Correct answer: C

Explanation

The correct answer is C, Many-to-Many (M:N), because multiple employees can be associated with multiple work locations and vice versa. The other options do not fit this scenario: A suggests a single employee can have many locations, B implies many employees are linked to one location, and D indicates a unique pair relationship which does not apply here.