2 (10 points). Consider relation Ships (name, class, launched) having the following characteristics 1. name is the key. 2. There are 100 pages in Ships. 3. Ships is clustered on class, so we expect that all the ships in a class can be found by reading a single page. 4. On average, there are 10 ships in any class and 25 ships launched in any year 5. Query SELECT FROM Ships WHERE name n has probability Pr 6. Query SELECT FROM Ships WHERE class -c has probability p2. 7. Query SELECT FROM Ships WHERE launched - y has probability ps 8. With probability 1-P1-P2-P3 there is an update on Ships. Consider the creation of indexes on name, class, and launched. For each combination of indexes, estimate the average cost of an operation. As a function of P1-0.25, P2-: 0.35, and P 0.2, what is the best choice of indexes? 2 (10 points). Consider relation Ships (name, class, launched) having the following characteristics 1. name is the key. 2. There are 100 pages in Ships. 3. Ships is clustered on class, so we expect that all the ships in a class can be found by reading a single page. 4. On average, there are 10 ships in any class and 25 ships launched in any year 5. Query SELECT FROM Ships WHERE name n has probability Pr 6. Query SELECT FROM Ships WHERE class -c has probability p2. 7. Query SELECT FROM Ships WHERE launched - y has probability ps 8. With probability 1-P1-P2-P3 there is an update on Ships. Consider the creation of indexes on name, class, and launched. For each combination of indexes, estimate the average cost of an operation. As a function of P1-0.25, P2-: 0.35, and P 0.2, what is the best choice of indexes