CASE Susan’s Special Sauces Difficulty Rating: 12 Database Case up SKILLS CHECK. You shouid ravi
CASE Susan's Special Sauces Difficulty Rating: 12 Database Case up SKILLS CHECK. You shouid raviowthe following areas Mow do y CASE BACKGROUND Susan's Special Sauces is a small company that produces a variety of salad dressings and sauces. Joy Giovanni, the company's owner, recently purchased a building on the outskirts of town and now wishes to become more organized with her record keeping, especially as it relates to inventory tracking. Initially, Joy wants you to build a database that allows her to monitor the inventory levels of the company's products. For instance, she would like to know current inventory levels, maximum inventory levels, minimum inventory levels, production costs, and selling prices for the company s products. She needs simple, effective forms for entering data her products. She needs reports that identify low-in- stock items and items that are currently in inventory. She also needs to extract specific information about the company's products and product categories from the database CASE SCENARIO Joy Giovanni owns and operates a small, Texas-based company called Susan's Special Joy named the company after her grandmother and one of her daughters. Susan's Sauces. produces and sells a variety of salad dressings and sauces, ranging from Special Sauces Creamy Italian Salad Dressing to Extra Spicy Barbecue Sauce. In the early years of her business, Joy prepared, packaged and sold a variety oi spaghetti sa at local and state Over the years, Joy increased her company's product fairs, conventions and flea markets. sauces, and steak ressings, pasta sauces, barbecue offerings to include gourmet salad d sauces. Susan's Special Sauces currently offers 20 products in five product categories Table 1 shows the company' current product list. 77