Taco Stand Database Tomas owns a taco stand and he needs a little data to help him do business. In his database he will track ingredients to make tacos and the different kinds of tacos he sells and, day by day, he will record the sales of tacos on his menu. He starts out by just listing his inventory each week. The ingredients are listed by name, preparation, units of measure and quantity on hand. The tacos he sells are going to have appealing names and he makes at least 10 kinds of tacos to choose from, sometimes up to 15. For each kind of taco he has on the menu, he gives it a zippy name, a list of ingredients and how much of each is used in one taco, a price, and instructions for building the taco so that employees at the stand know how to make them the same way every time. He’s been tracking how many of each taco he sells by day for 90 days. Tomas wants to be able to print a menu of taco names with their ingredients and prices. He needs a list of the tacos with instructions and the quantities of ingredients used so that employees can see what goes into each taco in what order. He will also evaluate which tacos are most popular and figure out what percentage of his sales comes from each kind of taco. Maybe he will make some decisions to discontinue the less popular ones, or raise the price a little on the more popular ones. Tomas also wishes to understand the average amount of shredded lettuce, diced tomatoes, sour cream, and guacamole he uses each month so that he will stop overbuying those ingredients. Now create from this given database Here’s the database you will design a database in Normalization Diagram Show transcribed image text Taco Stand Database Tomas owns a taco stand and he needs a little data to help him do business. In his database he will track ingredients to make tacos and the different kinds of tacos he sells and, day by day, he will record the sales of tacos on his menu. He starts out by just listing his inventory each week. The ingredients are listed by name, preparation, units of measure and quantity on hand. The tacos he sells are going to have appealing names and he makes at least 10 kinds of tacos to choose from, sometimes up to 15. For each kind of taco he has on the menu, he gives it a zippy name, a list of ingredients and how much of each is used in one taco, a price, and instructions for building the taco so that employees at the stand know how to make them the same way every time. He’s been tracking how many of each taco he sells by day for 90 days. Tomas wants to be able to print a menu of taco names with their ingredients and prices. He needs a list of the tacos with instructions and the quantities of ingredients used so that employees can see what goes into each taco in what order. He will also evaluate which tacos are most popular and figure out what percentage of his sales comes from each kind of taco. Maybe he will make some decisions to discontinue the less popular ones, or raise the price a little on the more popular ones. Tomas also wishes to understand the average amount of shredded lettuce, diced tomatoes, sour cream, and guacamole he uses each month so that he will stop overbuying those ingredients. Now create from this given database Here’s the database you will design a database in Normalization Diagram
Expert Answer
Answer to Taco Stand Database Tomas owns a taco stand and he needs a little data to help him do business. In his database he will …