For this assignment, use the conceptual model and the Cassandra column families given below. For this assignment ONLY us

[answerhappygod]

For This Assignment Use The Conceptual Model And The Cassandra Column Families Given Below For This Assignment Only Us 1 (29.66 KiB) Viewed 29 times

For This Assignment Use The Conceptual Model And The Cassandra Column Families Given Below For This Assignment Only Us 2 (55.24 KiB) Viewed 29 times

For This Assignment Use The Conceptual Model And The Cassandra Column Families Given Below For This Assignment Only Us 3 (67.07 KiB) Viewed 29 times

For this assignment, use the conceptual model and the Cassandra column families given below. For this assignment ONLY use the column families described below DRIVER PO INT ana VANCURSO MARCHASO) de DATE onder VARCHARCO POLICY POLICYHOLDER opoly INI DOPO INT POUCYHOLDER NE VARCHAR(SC) WAACHARSON CHURCO mal WICHUR(100) phone OVER POUCY policy IPF) INT OdPFO NT AP COVERAGE INT MARCURSO) DECIMAL) AGENT INT We WICHS WA CHUO ho CHURCIO VARCH AC100 POLICY d) INE pe VARCIUS) One DATE CATE D() TORCIMAL COVERAGE POUCH COOPERINT ODOOP NY CLAV Oncident de neden VE Odde de datud pay purpose ter
. 0 o . O O POLICY COVERAGES policylD policyholderID policyholder_firstname, policyholder_lastname policyeffectivedate policyexpirationdate coverageld o coveragetype coveragelimit PRIMARY KEY (policyID, coveragetype, coveragelimit, coveragels) POLICYHOLDER_PAYOUT policyholderID policyholder_firstname, policyholder_lastname, policyholder_email, policyholder_phone policylD • policytype policyeffectivedate policyexpirationdate policy deductible o claim incident date o claim status expenseld expense date disbursed expense amount o coverage type coverage limit . PRIMARY KEY (policyholderID, policylD policydeductible, claimstatus, expenselD) • ACTIVE_CLAIMS_BY_POLICYHOLDER Same columns as POLICYHODLDER_PAYOUT but different primary key PRIMARY KEY ((policyholderlD.policylD, claimstatus), expensel) ACTIVE_CLAIMS • Same columns as POLICYHOLDER_PAYOUT but different primary key PRIMARY KEY ((claimstatus, policyholderID). policy.D. expenselD) O D .
Write the CQL queries needed to meet each requirement below. Or, explain why a CQL query using the given column families cannot be written using only the column families provided. 1. For a specific policy holder, list all policy IDs and their respective effective and expiration dates. 2. For a specific policy holder, list all policy IDs, arranged by expiration date from newest to oldest 3. For a specific policy holder, list the coverage type and amount for all expenses. 4. For a specific policy holder, list the coverage type and amount for all expenses associated with claims that have a status of 'Open! 5. For a specific policy holder, give the total (sum) of all expenses. 6. For a specific policy holder, give the total (sum) of all expenses that have a disbursement date (not null). 7. For a specific policy, give the total (sum) of all coverages with a type of 'Personal property 8. For a specific policy, give the total (sum) of all expenses. 9. Show the policy ID for all policies with an effective date after January 1, 2022. 10. Show the ID for any policy that has a claim with a status of 'Open. Also include the policy holder information of first and last name, email address, and phone number. Submit your solutions as a .cal file. Put the problem number as a comment before each solution. For example: // Problem e: Show all user information // Not possible because..... 1/ Problem 1: Show all project information. SELECT