Practical Slip 14 - 2019 Pattern

 C Language:

Q1) Write a C program to check whether a input number is Armstrong number or not.

Q2) Write a program to accept a number and count number of even, odd and zero digits within that number.

DBMS:

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

Student (stud_reg_no, stud_name, class)

Competition (cno, cname, ctype)

Relation between Student and Competition is Many to Many

with rank and year as descriptive attribute.

Constraint: Primary key, class must be( “FY,SY,TY”).

Consider the above tables and execute the following queries:

1. Count total no students class wise.

2. Delete the details of student who has participated in “Mehandi” competation.

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

1. Display students from class 'FY’ and participated in 'E-Rangoli ' Competition.

2. Find the number of student for programming competition.

3. Display the names of first three winners of each competition.

4. Display average number of students participating in each competition.

5. Display total number of competition held in the year 2014.