Practical Slip 22 - 2019 Pattern

 C Language:

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

A B C

A B

A

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

Matrix.

1. Find sum of non diagonal elements of matrix

2. Find sum of all odd numbers of matrix

DBMS:

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

Train (train_no, train_name, depart_time, arrival_time,source_stn, dest_stn)

Passenger (p_id,p_name,address,age, gender)

Relation between Train and Passenger is Many to Many with seat_no, amount and date as descriptive attribute.

Constraint: Primary key, seat_no should not be null.

Consider the above tables and execute the following queries:

1. Display passenger names and their seat no’s of train “sahyadri express”.

2. Display details of train in which “Mr. Roy” is travelling from “Pune” to “Uruli

Kanchan”.

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

1. Display passenger details having age>50

2. Display total amount collected for “Kokan Express” on 5th January 2019.

3. Find total number of passenger of “Pune to Mumbai” route.

4. Cancel all the trains of 21st January 2019.

5. Calculate total number of male passenger in “Shatabdi Express”.