Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following incomplete list of business rules describes the relationships between different types of food-related businesses: Restaurants can be diners, pizzerias, delis, or none of

The following incomplete list of business rules describes the relationships between different types of food-related businesses:

Restaurants can be diners, pizzerias, delis, or none of these

Restaurants and grocery stores are food businesses, but not all food businesses are restaurants or grocery stores.

Some delis and pizzerias are take-out restaurants.

Some restaurants are sit-down only restaurants, but not all restaurants are sit-down only.

Supermarkets and supercenters are grocery stores, but not all grocery stores are supermarkets or supercenters.

Food manufacturers are food businesses, and can be canneries, packaging plants, both or neither. All relationships described in these rules are specialization-generalization relationships.

These rules also reflect the entities and relationships that exist in the real-world.

Business rules below: Here is a complete list of business rules that are consistent with the incomplete list given above:

Food businesses are entities that involve the production, distribution, and/or sale of food products.

Restaurants are a type of food business that provides prepared food for consumption on or off premises.

Grocery stores are a type of food business that sells food and household goods for consumers to purchase and take home.

Food manufacturers are a type of food business that involves the production of food products in large quantities.

Sit-down restaurants are a type of restaurant that provides a sit-down dining experience for customers.

Take-out restaurants are a type of restaurant that provides food for customers to take away.

Diners, pizzerias, and delis are types of restaurants that specialize in certain types of food. Some delis and pizzerias are also take-out restaurants, meaning they provide food for customers to take away.

Supermarkets and supercenters are types of grocery stores that sell a wide variety of food and household goods.

Some food manufacturers specialize in canning, packaging, or both. Not all food businesses are restaurants or grocery stores.

Question: Develop an extended entity-relationship diagram (EERD) that illustrates the relational database design described by the business rules above. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

More Books

Students also viewed these Databases questions

Question

What is Ramayana, who is its creator, why was Ramayana written?

Answered: 1 week ago

Question

To solve by the graphical methods 2x +3y = 9 9x - 8y = 10

Answered: 1 week ago

Question

Why does sin 2x + cos2x =1 ?

Answered: 1 week ago

Question

What are DNA and RNA and what is the difference between them?

Answered: 1 week ago

Question

5. What information would the team members need?

Answered: 1 week ago