Question

A few years have passed, and restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fifty states will not have ready access to data. Your supervisor has asked you to write a report to address the concerns of the customer and figure out how to expand the single server or single location database so the other 500 locations will be able to access and update the system. Write down in which you-

List 3 reasons why an organization may have a need for distributed databases and best practices for implementation of distributed database.

List and explain-

The software and hardware apparatus of a distributed database.

Techniques for distributed data placement.

Strategies for distributed query processing.

Briefly describe how an organization would allow programmatic access to a database through the Internet.

Please make any or all appropriate assumptions to answer the following.

Propose a solution for national restaurant chain on a distributed database system that will work for them.

Generate a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion.