Slip 21 - C) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. 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. Consider the above tables and execute the following queries: 1. Display premium amount paid by “Mr. Mahandule” since 1 Jan 2018. 2. Display the details of client who have taken policy “Jeevan Raksha”.

Solution:

Post a Comment

0 Comments