بتاريخ: 15 يونيو 20169 سنة comment_275961 Create an E-R Diagram for the given business rule.Business RuleThe following descriptions all have to do with a holding company for food service companies. You should answer each one separately from the others.Each chain consists of 50 to 300 stores that are owned by ACTME, the holding company for several restaurant chains and two caterers.Menu items are wide ranging, and can be classified by the section of the menu (appetizer, dessert, etc.) in which each is presented and by ethnic group (Italian, Hungarian, etc.) to which it belongs.The menu of each restaurant changes every couple months; management likes to keep track of past menus to track which ones have been successful.Each menu item is made of several ingredients (eggs, bacon, etc.) that are used in a certain quantity.Ingredients can be acquired from several suppliers. Ingredients are acquired by sending orders for several goods using the vendor's item numbers. The item number for each of these ingredients varies across suppliers, so if you are going to order eggs from supplier # 1, then you might order item 52 while from supplier # 2 you might order item J216. The company keeps price and item numbers for all the ingredients for all its menu items — and even for some ingredients which it is not currently using in any menu items. The quantity needed for each ingredient is also kept. The current price of these goods is maintained though the historical price is not. Because of special deals and volume discounts, the price at which a good is acquired is often different from its list price. Thus, the database must retain the price at which a good is actually acquired. تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.