Reference no: EM13332277

A few years have passed, and the 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 the 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 / single location database so the other 500 locations will be able to access and update the system. Write a 2-3 page paper in which you:
List three (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 components of a distributed database.

Techniques for distributed data placement.

Strategies for distributed query processing.

Briefly explain 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 the national restaurant chain on a distributed database system that will work for them.

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

Recognize the historical development of database management systems and logical data models.

Recognize the basic file organization techniques.

Describe the core concepts of data quality and their application in an organizational context.

Use technology and information resources to research issues in database systems.

Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.