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

HOTSPOT

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.

View Answer

Answer:

Explanation:

"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.

Reference: Appian Documentation: Data Modeling in Appian