Practical Slip 23 - 2019 Pattern

 C Language:

Q1) Write a C program to accept n elements of 1D array and then display sum of

all elements of array.

Q2) Accept n integers in an array. Copy only the non-zero elements to another array (allocated using dynamic memory allocation). Calculate the sum and average of non-zero elements.

DBMS:

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

Student (rno,sname,address,class)

Subject (subno,subname)

Relationship: - Student and Subject are related with many-to-many relationship with attribute marks and status.

Constraints: - Primary Key, class must be fy,sy,ty.

Consider the above tables and execute the following queries:

1. List the names of student class wise.

2. Display the marks of students subject wise.

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

1. List the distinct names of students who have either Electronics, or Statistics or both subjects.

2. List the names of students who are either passed or failed.

3. List the students who have “Database” subject and they are not in “TY” class.

4. List the names of students who are not failed in any subject.

5. List the names of students not staying at “Uruli Kanchan”.