Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need this typy of notation diagram for this question The company owns several stores, each has a unique store ID, a street address, and

image text in transcribed
i need this typy of notation diagram for this question

The company owns several stores, each has a unique store ID, a street address, and a postcode. Each store is managed by a store manager who is identified by a unique manager ID and a first and a last name. The date the manager took over the store is also stored. While each store is managed by a single manager, it is permitted for different stores to be managed by the same manager.

Each order (which is for one sandwich only, i.e., if a customer wishes to order n different sandwiches, he/she needs to make n different orders) has a unique (across all stores) order number, an order date & time indicating when the order was made, a completion date & time indicating when the order has been completed, and a cost in British pounds. Note that any order belongs to a single store, but any store can issue many orders.

Each menu item (sandwich) has a unique name, e.g., Tuna Heaven, and a unique menu item ID number. Each sandwich on the menu has a pre-fixed set of fillings, however, the number of fillings in different menu items vary. When making an order, the customer states the sandwich name (or the corresponding menu item ID) they would like to order, and since each sandwich has a pre-fixed set of fillings, the customer just needs to choose the type of bread they would like for their order. Each bread type has a unique name, e.g., Brown, White, Herbs & Cheese, and a price (pence per loaf). They also wish to store the total number of calories of each bread type. Note that all bread types have the same size so no need to store information about the loaf size.

Each filling has a unique ID, a unique name, e.g., Tomato, Tuna, Egg, etc., a price

(pence per gram) and calories (per gram). Each filling belongs to a category e.g., Vegetable, Poultry, etc. where each category is identified by a unique ID and has a distinct name.

Each sandwich is a combination of a set of fillings (each with a quantity in grams) and a type of bread. For instance, the menu item Tuna Heaven, consists of 200g of tuna, 150g of tomato, 100g of cucumber, 100g of lettuce, and 150g of gherkin, whereas the Big Egg menu item consists of 150g of egg, 120g of tomato and 100g of watercress. The cost of an order is computed as the sum of the product of the cost (per gram) of each filling used in the sandwich belonging to that order by the quantity of that ingredient used plus the cost for the chosen bread.

Among other things, your design should permit the following queries:

Listing orders by store(s), e.g., completed/pending orders by store X
Customers should be able to search for menu items and find out what fillings they contain and the prices for the different variants
Customers should be able to search for sandwiches by the category of their fillings,

e.g., sandwiches which contain vegetable and/or fish fillings but not red meat fillings etc.

Customers should be able to search for menu items by their calories, e.g., sandwiches which has 400 calories.
We can design the database schema and visualize answer then comment below

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_2

Step: 3

blur-text-image_3

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

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions