Active Orders

Question 1

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.

Question 2

• Imagine you are a DBA for a Regional Bank located in the South East. Your job is to ensure replication takes place between the branch offices and the main headquarters. Consider the use of snapshot, transactional, and merge replications, and provide an example of when each of these services could be used in the banking industry. Identify the service you would use and the reasons for your selection.
• Suppose your company has decided to use the MS SQL Server Integration Services. Using the Internet, research this service and determine the service that you would use. Provide a rationale for your response.

This is a discussion question and only requires 2 paragraphs