slips

Q.1) A) Write a C Program to accept a four digit number from user and count zero , odd and even digits of the entered number. [15 Marks]
B) Write a menu driven program in ‘C’ that shows the working of a library. The menu option should be
- Add book information.
Display book information.
Exit.
(Using Structure Array) [25 Marks]
Q.2) Consider the following Entities and Relationships [30 Marks] Customer (cust_no, cust_name, address, city) Loan (loan_no, loan_amt) Relation between Customer and Loan is Many to Many Constraint: Primary key, loan_amt should be > 0. Create a Database in 3NF & write queries for following.
Find details of all customers whose loan is greater than 10 lakhs.
List all customers whose name starts with 'ba'.
List names of all customers in descending order who has taken a loan in Nasik city.
Display customer details having maximum loan amount.
Calculate total of all loan amount.

Q.3) Draw a histogram to represent the following frequency distribution using
MS Excel.

Size of farm
In hectares
1-20
21-40
41-60
61-80
81-100
101-120
No. of farms
12
38
16
5
3
1 [10 Marks]

Q.4) Journal [10 Marks]

Q.5) Viva [10 Marks]

Q.1) A) Write a C program to generate the following pattern for n lines:

Aa Aa Bb Aa Bb Cc Aa Bb Cc Dd [15 Marks]
B) Write a ‘C’ Program to calculate factorial of given number by using recursion. [25 Marks]

Q. 2) Consider the following Entities and Relationships [30 Marks]
Department (dept_no, dept_name, location) Employee (emp_no, emp_name, address, salary, designation) Relation between Department and Employee is One to Many
Constraint: Primary key, salary should be > 0.
Create a Database in 3NF & write queries for following.
Find total