Database distribution strategy-simple database application

Assignment Help Data Structure & Algorithms

Reference no: EM13759412

Database Distribution Strategy/Simple Database Application

Part 1 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.

Part 2.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.

Reference no: EM13759412

Questions Cloud

Create teamwork in an organizational culture : How can you as manager create teamwork in an organizational culture that is not team oriented? What kinds of problems can you encounter using teams in an organizational environment? How do you handle relations between the team and the larger organiza..

Low-skilled employees performed routine tasks filling orders : A courier service laid off a large percentage of its production staff during last year's recession. These low-skilled employees performed routine tasks filling orders. The company now wants to rehire them. However, most of the unskilled employees hav..

What conclusion can you draw about commanders personality : What conclusion can you draw about Commander's personality?

Uses student teams to complete a complex design project : How should you as the professor distribute the few women engineering students among the project teams? Are there class actions you could take to provide support for the women students in the class? How do you handle complaints from women students abo..

Database distribution strategy-simple database application : 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 assign..

How assimilation is related to time and change threshold : Explain how assimilation is related to time and change threshold. Use an example related to IT to support your explanation

Measures of health : Identify a health issue of interest to you. Analyze this health issue using at least five health measures from epidemiologic literature or credible Websites.

Causes of and possible remedies for the problem : Recall a time when you experienced a problem as result of poor communication. What were the causes of and possible remedies for the problem?

The securities and exchange commission : If you were a consultant to a financial institution, what might you do to verify that FinQloud complies with the Securities and Exchange Commission (SEC) ruling and its 2003 interpretation?

User Account

All Pages