Practical Slip 2 - 2019 Pattern

 C Language:

Q1) Write a C program to accept radius of a circle and display the area and circumference of a circle.

Q2) Write a program to calculate sum of following series up to n terms.

Sum=X+X^2/2!+X^3/3!+......

(Note: Write separate user defined function to calculate power and factorial)

DBMS:

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

Sales_order (ordNo, ordDate)

Client (clientNo, ClientName, addr)

The relationship between Client & Sales_order is one-to-many.

Constraints: - Primary Key, ordDate should not be NULL.

Consider the above tables and execute the following queries:

1. Add column amount into Sales_order table with data type int.

2. Delete the details of the clients whose names start with ‘A’ character.

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

1. Delete sales order details of client whose name is “Patil” and order date is

“09/08/2019”.

2. Change order date of client_No ‘CN001’ to ‘18/03/2019’.

3. Delete all sales_record having order date is before ‘10 /02/2018’.

4. Display date wise sales_order given by clients.

5. Update the address of client to “Pimpri” whose name is ‘Mr. Roy’.