F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I -SOLVED PRACTICAL SLIP 2 (C-PROGRAMMING AND DBMS)@aishashaikh2717

F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I -SOLVED PRACTICAL SLIP 2 (C-PROGRAMMING AND DBMS)@aishashaikh2717
Q1. Write a C program to accept radius of a circle and display the area and circumference
of a circle. [15 Marks]
Q2. Write a program to calculate sum of following series up to n terms. [25 Marks]
Sum=X+X2/2!+X3/3!+……
(Note: Write separate user defined function to calculate power and factorial)
Q3. Consider the following entities and their relationships. Create a RDB in 3 NF with
appropriate data types and Constraints. [15 Marks]
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: [25 Marks]
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’.

Видео F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I -SOLVED PRACTICAL SLIP 2 (C-PROGRAMMING AND DBMS)@aishashaikh2717 канала Aisha Shaikh