Practical Slip 30 - 2019 Pattern

 C Language:

Q1) Write a program to find sum of digits of a given input number using user defined Function

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. 

Library(Lno, Lname, Location, Librarian, no_of_books)

Book(Bid, Bname, Author_Name, Price, publication)

Relation between Library and Book is one to many.

Constraint: Primary key, Price should not be null.

Consider the above tables and execute the following queries:

1. Display library details having number of books greater than 10000.

2. Display the list of books of ‘BPB’ publication.

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

1. Display publication wise number of books.

2. Display total price of books of ‘Nirali’ publication.

3. Delete the book details of Vision publication from ‘DPU’ Library.

4. Display all books of author whose initial character of name is ‘A’.

5. Update number of books of success publication to 1000 from DYP library.