Question

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

Answer 1

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