Practical Slip 20 - 2019 Pattern

 C Language:

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

1

2 3

4 5 6

Q2) Write a program to calculate addition of two matrices.

DBMS:

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

Wholesaler (w_no, w_name, address, city)

Product (product_no, product_name, rate)

Relation between Wholesaler and Product is Many to Many

with quantity as descriptive attribute.

Constraint: Primary key, rate should be > 0.

Consider the above tables and execute the following queries:

1. Update product_name to “Monitor” whose supplier is “Mr. Patil”.

2. Display product wise rate.

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

1. Display wholesaler from 'Pune' city and supplying 'Monitor'.

2. Display total number of wholesaler of each product.

3. Display all wholesalers who are supplying ‘Keyboard’ with maximum price.

4. Display total quantity of each product sold by ‘Mr. Khabia’.

5. Decrement rate of all products by 5% supplied by wholesaler from 'Pune ' city.