Practical Slip 21 - 2019 Pattern

 C Language:

Q1) Write a C program to generate following triangle up to n lines.

A

A B

A B C

Q2) Create a structure employee (eno, ename, salary). Accept details of n employees and write a menu driven program to perform the following operations options. 

1. Display all employees having salary > 5000

2. Display all employees

DBMS:

Q3) 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”.

Q4) Consider the above tables and execute the following queries:

1. Display Policy details having maturity amount >500000.

2. Find total number of policies purchased on 12th January 2019.

3. Find clients who have more than 3 policies.

4. Find all policies whose number of clients is same as that of policy ‘Jeevan

Raksha’.

5. Display policy wise client details.