Objective:

The purpose of this assignment is to design a distributed database system where data is stored in

various formats at different physical locations. This will involve understanding the principles of database

design, data distribution, and integration of heterogeneous data sources.

Requirements:

System Overview:

Provide a high$-$level overview of the distributed database system you are designing. Include the purpose

of the system, the types of data it will manage, and the users who will interact with it$.$ For example you

may think of a Bank with several branches, where data is stored in different formats in each branch, you

need to import or export the data to a unified format

Data Distribution:

Identify at least two different locations where data will be stored. Each location should use a different

data storage format. For example:

Location A: Relational database $($e$.$g$.,$ MySQL$,$ PostgreSQL$)$

Location B: NoSQL database $($e$.$g$.,$ MongoDB, Cassandra$)$

Explain why you chose these locations and formats.

Data Schema and Formats:

Design the schema for each data storage format. Provide detailed descriptions and diagrams where

necessary.

For relational databases, include tables, columns, data types, and relationships.

For NoSQL databases, include collections, documents, and fields.

Data Integration:

Describe how the distributed system will integrate data from these various formats and locations.

Consider the following aspects:

Challenges and Solutions:

Discuss potential challenges in managing a distributed database with heterogeneous data sources.

Provide solutions to address these challenges. Consider issues such as:

Data redundancy and inconsistency

Network latency and data transfer

Security and access control

Implementation Plan:

Outline the steps required to implement the distributed database system. Include:

Setting up the different data storage systems

Developing middleware or an integration layer to connect the data sources

Testing the system for functionality and performance

Deploying the system to a production environment

Use Case Scenarios:

Provide at least two use case scenarios demonstrating how users will interact with the distributed

database system. Include:

A step$-$by$-$step description of the user actions

The system$$s response to these actions

The flow of data across different locations

Deliverables:

A written report $(10-15$ pages$)$ that includes all the sections outlined above.

Diagrams and illustrations to support the design.

Submission Guidelines:

Submit your report as a PDF document.

Ensure that all diagrams are clear and well$-$labeled.