A Report On The Databakery Is A Homemade Goods Bakery With A Diverse Assortment Of Succulent Essay
1580 Words7 Pages
The DataBakery is a homemade goods bakery with a diverse assortment of succulent, delectable baked goods which can be readily viewed on www.databakery.com. We exist to deliver our baked goodies anywhere in the New England geographical region. As project sales forecasts have been shattered repeatedly and growth ensues, our firm feels the need to develop a comprehensive database to better collect, organize, and display important data necessary to optimize business operations.
The DataBakery would like to track our sales by each individual product. Tracking product sales would allow our firm to: determine what our most popular product lines are, what is being consumed the most, and how to alter our business strategy going forward based off of discovered trends in our well-organized data.
Customer purchases, in terms of quantity of transactions, customer name, address, phone number, email, the number of loyalty points they have accumulated, and overall customer expenditures per purchase are important pieces of data we wish to collect as part of our customer purchasing information. The customer loyalty points are an important field in our customers table. We wish to increment a particular customer’s loyalty points based on number of transactions and based on overall dollars and cents expended at DataBakery. These loyalty points would have implications of the customers receiving promotional offers, coupons, deals, discounts, and dollars off their purchases because we want to