Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business. Her database needs to be expanded and changed to meet the needs of the growing business. Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors.
-There are occasions when Marissa has orders from one customer for different monogram styles for the same product.Rather than creating separate orders for each item,she might use a(n)____ field to store the different monogram styles for the product in the Orders table.
A)Lookup
B)Linked
C)Multivalued
D)Relationship

Question

Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles,catalog products,orders,billing,customers,and vendors.
-There are occasions when Marissa has orders from one customer for different monogram styles for the same product.Rather than creating separate orders for each item,she might use a(n)____ field to store the different monogram styles for the product in the Orders table.
A)Lookup
B)Linked
C)Multivalued
D)Relationship

Quizplus · Accepted Answer

A multivalued field stores multiple values for the same field in a single record, which is suitable in this situation where there are different monogram styles for the same product in an order. Using a multivalued field would avoid the need to create separate orders for each item. Lookup fields are used to limit choices based on a list of values, linked fields establish a connection between tables, and relationships define how tables are related to each other. None of these options sufficiently address the situation of multiple monogram styles for the same product in an order.

Marissa's Monogram Business Has Expanded Exponentially Since She Added an Online