Answered step by step
Verified Expert Solution
Question
1 Approved Answer
e) Find the customers who bought a car insurance policy having a beneficiary of themselves. List those customers name, gender, and age. f) List the
e) Find the customers who bought a car insurance policy having a beneficiary of themselves. List those customers name, gender, and age.
f) List the nationality of customers who have bought car insurance having a max coverage is larger than $10,000.
g) Which customers (their names) bought all the insurance types from a provider whose code is AD16?
h) List the customers who live in Tucson as well as the annual fee of their insurance policies, if applicable.
[32 points) For each of the queries above, express tight lower and upper bounds of the cardinality of the resulting relation, given the input cardinalities, Customer, |Insurance Contract), and Policy - For example, for Profession (Customer), the bounds are: min(1, Customer)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started