Consider the following Entities and Relationships Client (client_no, client_name, address, birthdate) Policy_info (policy_no, desc, maturity_amt, prem_amt, date) Relation between Client and Policy_info is Many to Many Constraint: Primary key, prem_amt and maturity_amt should be > 0. Create a Database in 3NF & write queries for following. •Display Policy details having maturity amount >500000. •Find total number of policies purchased on 12th January 2013. •Find clients who have more than 3 policies. •Find all policies whose number of clients is same as that of policy ‘Jeevan Raksha’. •Display policy wise client details.
Answers
Answered by
1
Answer:
10 clients
Explanation:
Answered by
0
Answer:
10 clients
Explanation:
10 clients please mark me brainliest
Similar questions