schema design

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.

"Looking for a Similar Assignment? Order now and Get a Discount!