Practical Slip 5 - 2019 Pattern

 C Language:

Q1) Write a C program to accept dimensions length (l), breadth(b) and height(h) of a cuboids and display surface area and volume (Hint : surface area=2(lb+lh+bh ),

volume=lbh )

Q2) Write a program which accepts a sentence from the user and alters it as follows: Every space is replaced by *, case of all alphabets is reversed, digits are replaced by ?

DBMS:

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

Customer (cust_no, cust_name, address, city)

Loan (loan_no, loan_amt)

The relationship between Customer and Loan is Many to Many

Constraint: Primary key, loan_amt should be > 0.

Consider the above tables and execute the following queries:

1. Add Phone_No column in customer table with data type int.

2. Delete the details of customer whose loan_amt<1000.

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

1. Find details of all customers whose loan_amt is greater than 10 lakh.

2. List all customers whose name starts with 'D' character.

3. List the names of customer in descending order who has taken a loan from

Pimpri city.

4. Display customer details having maximum loan amount.

5. Update the address of customer whose name is “Mr. Patil” and loan_amt is

greater than 100000.