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.

Paet 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.

Submit your assignment for faculty evaluation.