Practical Slip 17 - 2019 Pattern

 C Language:

Q1) Write a C program to display multiplication table of a given input number

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

Matrix.

1. Display transpose of a matrix

2. Calculate sum of all odd elements of matrix

DBMS:

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

Politicians (pno, pname, telephone_no)

Party (party_code, party_name)

Relation between Politicians and Party is Many to One.

Constraint: Primary key, party_name should not be null.

Consider the above tables and execute the following queries:

1. Display the name of party whose politician is “Mr. Patil”.

2. Update party name of politician whose name is “Mr.Pawar”.

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

1. Display party names in ascending order.

2. Find the party who is having less number of members than ‘Congress’ party.

3. Display party wise politician name with details.

4. Display the party name with the details of politicians whose name include “Rao”.

5. Which party has maximum politicians