Question: CASE: Lena's Norwegian Bakery Shop. Build a database in Third Normal Form that can handle marketing of high-quality Norwegian foods through their bakery focused coffee

CASE: Lena's Norwegian Bakery Shop. Build a

CASE: Lena's Norwegian Bakery Shop. Build a database in Third Normal Form that can handle marketing of high-quality Norwegian foods through their bakery focused coffee shop that has hard to find bakery items from good ole Norway and in Vineland (North America). The staff of the bakery need to be able to categorize the products to help both their in-shop and online customers find the perfect items to complete a special Scandinavian meal or snack. Think carefully about the characteristics/attributes of the food items that customers and Lena's staff would need to know. This would include things such as: section of the shop where found, category of food item, allergies (Gluten Free, Contains Nuts, etc.), requires freezing or refrigeration, price, and quantity on hand, and whether made-in-shop or where from country and state/province. The staff and management of Viking Foods also want to know information on their customers such as their names, addresses, emails and phone numbers so that they can inform them of specials or let them know when their orders are ready for pickup or home/office delivery. [DON"T worry about the customer orders and sales.] Some example Lena's Bakery items include: Lefse, Cloudberry Crispy Waffles, Cardamom Rolls, Kransekage, Krumkake, Goro, Fattigmann, Sandbakkels, Rosettes, Spritz, Sirupsnipper, Kolakaker, Vafler, and Icelandic Pancakes, etc. Design a Database In 3NF to handle Lena's database needs Try to keep the database simple yet handle a growing business. Write a query that counts up the number of unique type of bakery products from every country, by state/province and keeps track of the country, state/provinces that there are 10 or more types of products from. List the country, state/province, and number of types of products in alphabetical order

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!