Schema Design - Constant access to a list of active orders

Question # 00805344 Posted By: dr.tony Updated on: 05/08/2021 06:48 AM Due on: 05/08/2021
Subject Education Topic General Education Tutorials:
Dot Image

Schema Design

Question Description

Imagine you needed to scale the sample restaurants database to accommodate a larger chain. Here are some of the features this new chain will need:

  • Constant access to a list of active orders, and the ingredients in them.
  • Live inventory reporting.
  • Monthly reporting on most frequently used ingredients.

After reviewing the current schema of the sample database, think of at least 3 types of queries that would need to be added or changed to add the features mentioned above. In a 1-2-page paper, explain how these new queries would display the data needed by the larger chain and provide examples of each query.

Dot Image
Tutorials for this Question
  1. Tutorial # 00800374 Posted By: dr.tony Posted on: 05/08/2021 06:49 AM
    Puchased By: 2
    Tutorial Preview
    The solution of Schema Design - Constant access to a list of active orders...
    Schema_Design_-_Constant_access_to_a_list_of_active_orders.ZIP (18.96 KB)

Great! We have found the solution of this question!

Whatsapp Lisa