Discuss Appian ACD201 Exam Topic 2 Question 3

You need to relate two entities, Employee and Skill, in the data structure. You want to adhere to Appian best practices.

Employees can have multiple skills, and a single skill can relate to multiple employees.

What type of relationship do these entities represent, and what is the minimum number of tables required to implement the design?

AMany-to-many; 3 tables

BMany-to-many; 2 tables

COne-to-many; 2 tables

Suggested Answer: A

The relationship between Employee and Skill is many-to-many - an employee can have multiple skills, and each skill can belong to multiple employees.

To model this properly and according to Appian best practices, you need 3 tables:

Get Premium ACD201 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

14 comments · newest first

Val 10 months ago

Wait, how can it be 2 tables for many-to-many? Seems off.

Galen 10 months ago

I think it's just 2 tables, right?

Herminia 10 months ago

Definitely a many-to-many relationship!

Elena 10 months ago

Yup, 3 tables is the way to go!

Micheline 10 months ago

I agree, 3 tables makes sense for this setup.

Reynalda 11 months ago

I’m a bit confused; I thought many-to-many relationships typically needed just two tables, but now I’m second-guessing myself.

Macy 11 months ago

I feel like it might actually require three tables because we need a junction table to link employees and skills.

Tammara 11 months ago

I remember practicing a similar question, and I think it was two tables for a many-to-many relationship, but I could be wrong.

Janna 11 months ago

I think this is a many-to-many relationship since employees can have multiple skills and vice versa. But I'm not sure about the number of tables needed.

Kimi 12 months ago

I'm pretty confident this is a many-to-many relationship, so I'll select option A. The minimum number of tables required is 3 to properly implement the design.

Tresa 12 months ago

I'm a bit confused on the minimum number of tables required. I'll need to review the best practices for implementing many-to-many relationships in Appian.

Ngoc 12 months ago

Okay, the key is that employees can have multiple skills and a single skill can relate to multiple employees. That sounds like a many-to-many relationship to me.

Rachael 1 year ago

Hmm, I'm not sure if we need 3 tables or just 2. I'll have to think this through carefully.

Carylon 1 year ago

I think this is a many-to-many relationship, so I'll go with option A.

Appian ACD201 Exam - Topic 2 Question 3 Discussion