Practical Slip 19 - 2019 Pattern

 C Language:

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

* * * *

* * *

* *

*

Q2) Write a menu driven program to perform the following operation on m*n

Matrix 

1. Find sum of diagonal elements of matrix

2. Find sum of all even numbers of matrix

DBMS:

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

Item (item_no, item_name, quantity)

Suppliers (sup_no, sup_name, address, city, phone_no)

Relation between Item and Supplier is Many to Many with rate and

discount as descriptive attribute.

Constraint: Primary key, phone_no must be 10 digits.

Consider the above tables and execute the following queries:

1. Display item wise quantity.

2. Display Suppliers whose names are starting with ‘s’ character.

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

1. Delete items having quantity less than 2.

2. Display total number of suppliers who are supplying ‘Refrigerator’.

3. Display all suppliers supplying ‘Washing Machine’ with minimum cost.

4. Give supplier details who give maximum discount on each item.

5. List suppliers supplying maximum number of item.