Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Appian ACD200 Exam - Topic 4 Question 70 Discussion

You are creating an ERD that models the data for a college and includes a Many-to-Many relationship, Student-to-Class, where a student can be enrolled in multiple classes, and a class can enroll multiple students.How can you handle this relationship so that it can be supported in Appian and remain in at least First Normal Form? (Choose the best answer.)
A) A joining table can be used to hold instances of Student/Class relationships.
B) The Student table should have a Class field to hold an array of Class IDs.
C) The Class table should have a Student field to hold an array of Student IDs.
D) It cannot be done, because Appian CDTs cannot handle Many-to Many relationships.

Appian ACD200 Exam - Topic 4 Question 70 Discussion

Actual exam question for Appian's ACD200 exam
Question #: 70
Topic #: 4
[All ACD200 Questions]

You are creating an ERD that models the data for a college and includes a Many-to-Many relationship, Student-to-Class, where a student can be enrolled in multiple classes, and a class can enroll multiple students.

How can you handle this relationship so that it can be supported in Appian and remain in at least First Normal Form? (Choose the best answer.)

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

0/2000 characters
Antonio
10 hours ago
This question reminds me of a similar practice one we did about managing enrollments. I think the joining table option is definitely the best choice.
upvoted 0 times
...
Arthur
6 days ago
I'm not entirely sure, but I think storing arrays in the Student or Class tables might violate First Normal Form.
upvoted 0 times
...
Fairy
11 days ago
I remember we talked about using a joining table for Many-to-Many relationships in class. That seems like the right approach here.
upvoted 0 times
...

Save Cancel