
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.
References
* Appian Documentation: Data Modeling in Appian