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 .cql file. Put the problem number as a comment before each solution. For example: // Problem 0: Show all user information, // Not possible because... // Problem 1: Show all project information. SELECT ...
Added by Kristin C.
Close
Step 1
Is it due to limitations, lack of resources, or other factors? Show more…
Show all steps
Your feedback will help us improve your experience
Adi S and 100 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
PA 13-3 (Algo) Monsanto sells genetically modified seed to farmers. It needs to decide how much seed to put into a warehouse to serve demand for the next growing season. It will make one quantity decision. It costs Montanso $8 to make each kilogram (kg) of seed. It sells each kg for $45. If it has more seed than demanded by the local farmers, the remaining seed is sent overseas. Unfortunately, it only earns $3 per kg from the overseas market (but this is better than destroying the seed because it cannot be stored until next year). If demand exceeds its quantity, then the sales are lost—the farmers go to another supplier. As a forecast for demand, it will use a normal distribution with a mean of 325,000 and a standard deviation of 150,000. Use Table 13.4. a. How many kilograms should Montanso place in the warehouse before the growing season? Use Table 13.4 and round-up rule. b. If Montanso put 375000 kgs in the warehouse, what is its expected revenue (include both domestic revenue and overseas revenue)? Use Table 13.4 and round-up rule. c. How many kilograms should Montanso place in the warehouse to minimize inventory while ensuring that the stockout probability is no greater than 10%? Use Table 13.4 and round-up rule. d. What is maximum profit for this seed?
Adi S.
Akash M.
The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) Where: - Employee table contains employee details and empNo is the key. - Department table contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager for each department. - Project table contains details of the projects in each department and the key is projNo (no two departments can run the same project). - WorksOn table contains details of the hours worked by employees on each project, and empNo/projNo/dateWorked form the key.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD