Question: 1. Develop an extended entity-relationship diagram (EERD) that illustrates the relational database design described by the business rules in #1. The diagram should include the

1. Develop an extended entity-relationship diagram (EERD) that illustrates the relational database design described by the business rules in #1. The diagram should include the primary key of each table in order to demonstrate correct implementation of specialization-generalization. While EERDs may well contain other attributes, in this assignment you need not include them because they are not described in the business rules. You should use legal database identifiers such as Sit_Down_Restaurants or Food_Manufacturers in your EERD. 1.Please find the business rules which are applicable logically in the real world *. Restaurants and grocery stores are food businesses, but not all food businesses are restaurants or grocery stores. Explanation - Food business has a relation with Restaurants and groceries. Food business is the main context here. Food business may be anything in the world but includes restaurants and groceries. *. Restaurants may be either diners, pizzerias, delis, or none of these. *. Supermarkets and supercenters are grocery stores, but not all grocery stores are supermarkets or supercenters. Explanation - grocery store which is under food business has a relation with Supermarkets and Supercenters. Other grocery stores may also present here except supermarkets and supercenters. *.Some delis and pizzerias are take-out restaurants. Some of delis and pizzerias restaurants are only for take out restaurants and dont have dine - in present. These restaurants take the orders and delivers to customer address. *. Some restaurants are sit-down only restaurants, but not all restaurants are sit-down only. Explanation - Restaurants except some delis and pizzerias are only sit-down restaurants and dont have take out option. They donot deliver to the customer address. *. Food manufacturers are food businesses, and can be canneries, packaging plants, both or neither. Explanation - Food manuifacturers are also included in food business where they manufacture canneries and package foods. Food manufacturers can manufacture canneries or package plants or both or neither of these(any others). Conclusion - 1.Food business consists of Restaurants, groceries , food manufacturers and others. 2.Some Restaurants are only sit-down and some are only take out. 3.Super markets and Super centers belongs to groceries and groceries also contains others.

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 Databases Questions!