Practical Slip 15 - 2019 Pattern

 C Language:

Q1) Write a C program to check whether a input number is perfect number of not.

Q2) Write a program having a menu with the following options and corresponding actions

DBMS:

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

Plan (plan_no, plan_name, nooffreecalls, freecalltime, fix_amt)

Customer (cust_no, cust_name, mobile_no)

Relation between Plan and Customer is One to Many.

Constraint: Primary key, fix_amt should be greater than 0.

Consider the above tables and execute the following queries:

1. Display the details of plan who has taken by “Mr. Patil”.

2. Update the mobile No of customer to 7020079536 whose name is “Mr

Roy” and plan is “Go Max”.

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

1. Display the plan having minimum response.

2. Display customer details starting their mobile number with 98.

3. Display the customer details that are getting less number of free calls than that of

the plan ‘Let’s Rock’.

4. Delete the details of ‘John’ who has stopped ‘Go Max’ plan.

5. Find the plan whose fixed amount is greater than 5000.