Short Answer Type Questions 1. Explain the idea of fragmentation and its needs in distributed database system design. 2. What is the Location Mapping Schema in Distributed Databases? 3. Why local mapping transparency is advantageous while designing queries in distributed database concepts. 4. Explain when fragmentation for a relation is not advantageous in distributed database design. 5. Critically comment on storage cost and availability in light of distributed database design concepts. Long Answer Type Questions 35=15 HealthyCare is a medical group based in Kolkata that provides various medical support to patients. The group has several doctors from different domains of specialization associated with them /Eg. Cardiology, Neurology, Orthopedics, Ophthalmology). Patients can register to become registered members of HealthyCare and appoint for treatment (online or offline) to a particular domain based on the experience of the doctors 5 years to 25+ years), but not to a specific doctor directly. HealthyCare plans to expand its operations to three other cities and they want to maintain its database in a distributed manner. As a database designer, you are asked to help them by answering the following questions. (Write all of your assumptions properly) 1. Analyze the tables needed and how we can fragment them and 5 allocate them in different cities to minimize the workload for each site, and also increase data availability using data duplication. 2. Suppose that the HealthyCare head office is located in Kolkata, and 5 they want to understand whether cardiac problems are becoming a common issue nationwide, and how patients are attempting to appoint doctors for this domain. To achieve this goal, design suitable queries for three levels of transparency. a. Count the number of patients who have been diagnosed with cardiac problems in the past year. b. Calculate the percentage of patients diagnosed with cardiac problems out of the total number of registered patients. 3. Rethink the fragmentation. Redesign the fragments in such a way 5 that the number of joins, network overhead, and other costly operations is reduced. Write all necessary details and assumptions to design the fragments