Practical Slip 16 - 2019 Pattern

 C Language:

Q1) Write a C program to calculate x^y without using standard library function.

Q2) Write a program to display union and intersection of two 1D array.

DBMS:

Q3) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints.

Employee (emp_id, emp_name, address)

Investment (inv_no, inv_name, inv_date, inv_amount)

Relation between Employee and Investment is One to Many.

Constraint: Primary key, inv_amount should be > 0.

Consider the above tables and execute the following queries:

1. Display the details of employee who has invested amount in “Mutual Fund”.

2. Add column Phone_No in Employee table.

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

1. Display employee details who have invested more than 100000.

2. Display employee wise total investment amount.

3. Display the employee names who invest on date 2nd Jan 2013.

4. Display employee whose investment are more than 3.

5. Find average investment of employees of Pune.