Appian Exam ACD100 Topic 2 Question 37 Discussion

Actual exam question for Appian's ACD100 exam

Question #: 37
Topic #: 2

What table relationship is illustrated in the following data structure (if the relationship is evaluated from left to right)?

AMany to Many (M:M)

BMany-to-One (M:1)

COne-to-Many (1:M)

DOne-to-One (1:1)

Show Suggested Answer

Suggested Answer: B

This relationship is a 'one-to-many' relationship because one supplier can supply many different products, but each product can only be supplied by one supplier.

by Michell at Sep 16, 2024, 01:18 AM

Limited Time Offer

25%

Off

Get Premium ACD100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jeniffer

6 months ago

Wow, these database questions can be so confusing! But I think the answer here is C) One-to-Many (1:M). It just makes sense based on the way the data is structured.

upvoted 0 times

...

Maryann

6 months ago

This is a tricky one, but I'm going with C) One-to-Many (1:M). The direction of the arrows indicates that the relationship flows from Department to Employees, not the other way around.

upvoted 0 times

Alise

4 months ago

The arrows clearly indicate the flow of the relationship, leading to the conclusion of One-to-Many (1:M).

upvoted 0 times

...

Stephanie

5 months ago

It's definitely not Many to Many (M:M) or One-to-One (1:1) based on the structure.

upvoted 0 times

...

Dorothy

5 months ago

I agree, the arrows show that each department can have multiple employees, supporting the One-to-Many relationship.

upvoted 0 times

...

Johnathon

5 months ago

I see your point, but I still believe it's C) One-to-Many (1:M) because each department can have multiple employees, but each employee is associated with only one department.

upvoted 0 times

...

Elden

5 months ago

I think you're right, C) One-to-Many (1:M) makes sense based on the data structure.

upvoted 0 times

...

Shannan

5 months ago

I agree with you, C) One-to-Many (1:M) seems to be the correct choice based on the data structure.

upvoted 0 times

...

Blondell

5 months ago

I think it's A) Many to Many (M:M) because each department can have multiple employees and each employee can work in multiple departments.

upvoted 0 times

...

Florinda

6 months ago

Ha! This is easy. It's clearly a One-to-Many (1:M) relationship. The diagram shows that one Department can have multiple Employees, but each Employee is connected to only one Department.

upvoted 0 times

...

Leonie

6 months ago

Hmm, the way I see it, this is a Many-to-One (M:1) relationship. Each Department has multiple Employees, but each Employee is associated with only one Department.

upvoted 0 times

Loreen

5 months ago

I see it as a Many-to-One (M:1) relationship. Each Employee is linked to one Department, but each Department can have multiple Employees.

upvoted 0 times

...

Genevive

5 months ago

Great, thanks for the clarification!

upvoted 0 times

...

Carlene

5 months ago

So, the correct answer is B) Many-to-One (M:1).

upvoted 0 times

...

Gretchen

5 months ago

I agree with you, it looks like a One-to-Many (1:M) relationship. Each Department can have many Employees, but each Employee is linked to only one Department.

upvoted 0 times

...

Carol

5 months ago

I agree, each Department can have multiple Employees but each Employee belongs to only one Department.

upvoted 0 times

...

Misty

5 months ago

I think it's a Many-to-One (M:1) relationship too.

upvoted 0 times

...

Tonette

6 months ago

I think it's a One-to-Many (1:M) relationship. Each Department can have multiple Employees, but each Employee is associated with only one Department.

upvoted 0 times

...

Rochell

7 months ago

I'm not sure, but I think it could also be Many-to-One (M:1) since many employees can belong to one department.

upvoted 0 times

...

Avery

7 months ago

I think the answer is C) One-to-Many (1:M). The diagram shows that each Department can have multiple Employees, but each Employee can only belong to one Department.

upvoted 0 times