Practical Slip 25 - 2019 Pattern

 C Language:

Q1) Write a C program to calculate sum of all even elements of a matrix.

Q2) Write a menu driven program for the following option

1. Check input number is Armstrong or not

2. Check input number is Perfect or not

DBMS:

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

College (code, college_name, address)

Teacher (teacher_id, teacher_name, Qualification, specialization, salary, Desg)

Relation between Teacher and College is Many to One.

Constraint: Primary Key, qualification should not be null.

Consider the above tables and execute the following queries:

1. List the name of staff having qualification is “SET-NET”.

2. Update the salary of teacher to 50000 whose qualification is “PhD”.

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

1. List the college wise staff.

2. Display the details of Teachers who are working in Dr. D Y Patil College and their

specialization is “Computer”.

3. Display the designation of teacher whose name is “Mr Patil” and he is working in

DPU college.

4. Display teacher wise salary.

5. Update an address of college to “Sant Tukaram Nagar” whose name is “MD College”.