Database distribution strategy

Assignment Help Database Management System

Reference no: EM13766734

Database Distribution Strategy

For this assignment, you will design and develop a distributed database infrastructure for an organization of your choice. You may use the database you created in another unit or you may choose to create a new database to work with for this assignment. Use external research and the suggested resources to design your infrastructure.

In preparation for this assignment, it is important to understand distributed database management systems that support modern service-oriented systems and cloud computing.

Assignment Instructions

For this assignment, complete the following:

Develop a distributed database infrastructure using entity relationship diagrams (ERDs) and unified modeling language (UML) diagrams and develop a written analysis to support and describe your infrastructure.

Identify a list of steps for implementing distributed databases that are specific to your organization.

Discuss the benefits and challenges related to distributed database implementation maintenance relevant to security and the lack of standards and standardized methodology.

Describe a strategy for maintenance and security of the distributed system you created; include topics related to local and global applications.

Defend your maintenance and security plan with strongly supported rationale.

Your completed assignment should include the following:

A physical design of a distributed database that is appropriate for your chosen organization.

An analysis of a physical design for a distributed database providing appropriate rationale for resource allocation and device placement.

A discussion of the benefits and challenges related to maintenance, implementation, and security of a distributed database.

A strategy for maintenance and security of a distributed system that includes local and global application integration.

Simple Database Application

For this assignment, you will develop a simple database application utilizing the database that you have created for the first assignment in this unit. It may be a simple reporting application that simply queries two tables or a data entry application that has input fields to insert the data into the database.

In preparation for this assignment, it is important to understand the relationship between the database and the application. Use the suggested resources or other resources you find to learn more about this topic.

Assignment Instructions

For this assignment, complete the following:

Create a simple database application using either PHP, ASP.NET, C#, Java or Visual Basic that uses at least two tables. Note you can use views, too, to simplify the SQL code from the application.

Provide the fully documented code for your application and all ancillary project files.

Describe your goal or goals for the application. What are you trying to achieve? Which users would be using the application?

Describe your rationale for the application you created and the tables you used.

Your completed assignment should include the following:

A simple database application that accurately represents business needs.

A detailed and accurate analysis of your simple database application.

Screenshots of your functional application.

Appropriate rationale for your chosen application design and implementation.

Refer to the Simple Database Application scoring guide to ensure that you meet the grading criteria for this assignment.

Reference no: EM13766734

Questions Cloud

Describe the core conflict represented in the given story : Describe the core conflict represented in the story. Describe the theme of the story. Select three literary elements/techniques in the story and describe them.

Fault-tolerant architecture and disaster recovery strategy : This assignment will give you the opportunity to provide a backup strategy and disaster recovery plan to protect the organization against disruptions to the availability of the system. In this final assignment, focus on the most critical system th..

Financial statements and in determining income taxes : Is it necessary for a business to use the same method of computing depreciation (a) for all classes of depreciable assets, (b) in the financial statements and in determining income taxes? Explain your answer.

What is the frequency of resonance : What is the frequency of resonance and what is the vertical dimension of the van interior - Your graph should include time and sound pressure axes with scales to show the ranges for the signal you have sketched.

Database distribution strategy : Database Distribution Strategy. For this assignment, you will design and develop a distributed database infrastructure for an organization of your choice. You may use the database you created in another unit or you may choose to create a new datab..

Ameliorate the burden of international double taxation : In no less than 225 words, describe three of the described systems that are either currently used or proposed to ameliorate the burden of international double taxation

Environmental policy issues : Describe the economic impact of the law. Provide specific economic data from credible references.

Analytics-management science or model challenge in the real : The last section of the report should discuss the future opportunities and challenges of solving the problem. What will help solutions improve? What limitations remain?

Do the legal principles apply to vehicles : Do the legal principles apply to vehicles such as bicycles, rowboat, motor homes, trains or airplanes

User Account

All Pages