Question

Q3. Consider the following entities and their relationships. Create a RDB in 3 NF with
appropriate data types and Constraints. [15 Marks]
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".

Answer 1

Answer:

Java the coding class will be read by three years Java by complete course