Distributed Databases Scenario: you are hired as a consultant, specialising in distributed databases! For each of the following scenarios, explain which distribution strategy is best to overcome the problem. 1: For a Sharepoint site, you have users located in both Melbourne and Singapore. Both need full access to all of the data at maximum speed. The data, however, gets updated very rarely (say once every 3 months). 2: For the Salesforce Customer Relationship Management system, you have users located in both Asia and Europe. However, generally, SOME rows in the tables are used more regularly in Asia (e.g., salespeople in China look up more records for customers in China), and some are used more regularly in Europe (likewise for France). Not many analytical queries involving data from other regions are required, and in general, updates are happening to tables very rapidly. 3: For the Australian Football League information website, its users are based primarily in the Australian region (nearby the DB in Sydney), and in general the performance of the DB is currently acceptable and data is being backed up already offsite safely. If the service goes down for hours to days, it’s not ideal but not mission critical to the business. 4: For the National Gallery of Victoria (NGV) database, its users are mainly people who love art in the Australian region. Therefore, speed is essential for these users, to access basic information about NGV's art collection and a preview image of less than 1MB. However, the NGV also stores very high-resolution image data (up to 1GB) in Silicon Valley (USA) due to cheaper cost of storage there; these large image files are accessed mostly by arts scholars, at most twice a month.