You are required to design a DDBM system:

1. Select a particular application (Manufacturing, Airlines, Hotels, etc.) for the design of a distributed database management system.
2. Research and present attributes of two (2) tables from the selected application in (a) above.
3. Populate about ten records each into the tables specified in (b) above.
4. Show how you will partition one of the tables vertically into two (2) servers located at different sites.
5. Partition the second table horizontally using any partitioning strategy. Justify the selection of that particular strategy.
6. Select and sketch the distributed database architecture (consisting of at least 2 locations) for your application. Justify your selection of that particular architecture.
7. Mention two different DDBMS software you will install on the two locations. Justify your choice.
8. Mention one middleware you will employ to connect the two databases. Justify your choice.
9. Write a materialized view query to select columns from the tables in (d) above, which were partitioned and placed on two different servers.
10. Which replication scheme will you use to replicate data across the locations? Justify your choice.
11. To help improve performance of your application, describe the parallelism technique you will employ.

Answer rating: 100% (QA)

Designing a Distributed Database Management System DDBMS is a complex process Ill provide an example of a DDBMS design for a Hotel Management application as requested Keep in mind that this is a simpl... View the full answer