Module 4

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.