• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Database Design > Multivalue Fields

Multivalue Fields

Suppose you're a company that sells food items, like Northwind. You have a Products table with all the items you sell, with one row for each item: ice cream, yogurt, nondairy creamer, and so on. Among the columns, you include a field to store all the flavors for that item: vanilla, blueberry, Irish crème (see Table 2.14).

Table 2.14. Tables That Include Multivalue Fields
Products
ProductSupplierFlavors<<other fields>>
Ice creamFrozen DelightsVanilla, Chocolate, Strawberry 
YogurtHeavenly CulturesVanilla, Blueberry, Asparagus, Strawberry 
Nondairy CreamerFoodstuffs Inc.Vanilla, Asparagus, Hazelnut 



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint