Consider the following Entities and RelationshipsClient (client_no, cl

1.	Consider the following Entities and RelationshipsClient (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..Display premium amount paid by “Mr. Mahandule” since 1 Jan 2018..Display the details of client who have taken policy “Jeevan Raksha”.
Answer» Explanation: 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. /

Consider the following Entities and RelationshipsClient (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..Display premium amount paid by “Mr. Mahandule” since 1 Jan 2018..Display the details of client who have taken policy “Jeevan Raksha”.

Answer»

Explanation:

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. /