Schema Design - Constant access to a list of active orders
Question # 00805344
Posted By:
Updated on: 05/08/2021 06:48 AM Due on: 05/08/2021
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.
-
Rating:
/5
Solution: Schema Design - Constant access to a list of active orders