Case-Based Critical Thinking Questions
Case 12-2
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

Case-Based Critical Thinking Questions
Case 12-2
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

Multivalued fields allow for multiple values to be stored in one field, which is useful in situations such as Marissa's where a customer may order multiple products with different monogram styles. Using a multivalued field in the Orders table would allow for all of the monogram styles to be stored under one order, rather than creating separate orders for each style. A lookup field would not be appropriate in this situation as it only allows for one value to be selected from a list, and a linked field is used to connect records between different tables. A relationship field is used to connect records between different tables as well.