Match each scenario to the correct relationship type in your data model design.
Note: Each relationship type will be used once. To change your responses, you may deselect your response by clicking the blank space at the top of the selection list.
"You have a product with basic fields and an additional detailed product description with all the technical details that is regularly updated." - One-to-many
"You have many employees on multiple projects." - Many-to-many
"You have an order with order items." - One-to-many
A one-to-many relationship is used when a single record from one table (product) is associated with multiple records in another table (product descriptions).
A many-to-many relationship exists when multiple records from one table (employees) are associated with multiple records from another table (projects).
An order with order items also represents a one-to-many relationship where one order can have multiple order items.
References
Appian Documentation: Data Modeling in Appian
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit