Think about how you would organize a data warehouse for Marathon Vitamin Shops. What other databases would you like to merge into the data warehouse? What sort of patterns should Bill Berry be looking for? Identify these patterns by type (associations, sequences, clustering, or trends) and discuss them in a page or two.

One of Marathon Vitamin Shops’s employees, Esther See, approaches the owner, Bill Berry, about an observation she had. “I’ve noticed that our customers have different habits. Some come in regularly, and others are less predictable,” Esther says. “When I see a regular customer, I pride myself on knowing what the customer will buy and maybe even suggest other vitamins they might like. I think I generate more sales that way. The customer is happier, too.”