Practical Slip 8 - 2019 Pattern

 C Language:

Q1) A cashier has currency notes of denomination 1, 5 and 10. Write a C program to accept the withdrawal amount from the user and display the total number of currency notes of each denomination the cashier will have to give.

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

Matrix.

1. Calculate sum of upper triangular matrix elements

2. Calculate sum of diagonal elements

DBMS:

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

Book (Book_no, title, author, price, year_published)

Customer (cid, cname, addr)

Relation between Book and Customer is Many to Many with quantity as

descriptive attribute.

Constraint: Primary key, price should be >0.

Consider the above tables and execute the following queries:

1. Display the name of book whose author is “Mr. Gadhave”.

2. Add column EMailId into customer table.

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

1. Display customer details from 'Mumbai'.

2. Display author wise details of book.

3. Display customer name that has purchased more than 3 books.

4. Display book names having price between 100 and 200 and published year is 2019.

5. Update the title of book to “DBMS” whose author is “Mr. Talore”.