RDBMS Assignment 4

ASSIGNMENT 4 SOLUTION WITH SOURCE CODE

Functions

Contents:

1. Set A
• Q.1
• Q.2
• Q.3
2. Set B
• Q.1
• Q.2
• Q.3

Set A

Q 1. Write a function which will return minimum maturity amount of all policies.

 Download code        Source code 

Q 2. Write a function which will return total number of policies opened no “1Jan-2020”

 Download code        Source code 

Q 3. Write a function which will return total maturity amount of policies of a particular client.

 Download code        Source code 

Set B

Q 1. Write function to print the total number of suppliers whosupplies “Keyboard”.

 Download code        Source code 

Q 2.Write function which will return rate of “Harddisk” supplied by “Mr. Patil”.

 Download code        Source code 

Q 3. Write function which will take supplier number as input and print the total number of items supplied by him.

 Download code        Source code