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 joining table can be used to hold instances of Student/Class relationships.
- The Student table should have a Class field to hold an array of Class IDs.
- The Class table should have a Student field to hold an array of Student IDs.
- It cannot be done, because Appian CDTs cannot handle Many-to Many relationships.
Reveal Solution Next Question