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

F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I - SOLVED PRACTICAL SLIP 4(C-PROGRAMMING AND DBMS)@aishashaikh2717
Q1. Write a C program to accept two numbers and print arithmetic and harmonic mean of
the two numbers (Hint: AM= (a+b)/2 ,HM = ab/(a+b) ) [15 Marks]
Q2. Create a structure Student (id, name, marks). Accept details of n students and write a menu driven program to perform the following operations. [25 Marks]
a) Search student by id
b) Display all students
Q3. Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. [15 Marks]
Patient (PCode, Name, Addr, Disease)
Bed (Bed_No, RoomNo, loc)
Relationship: - There is one-one relationship between patient and bed.
Constraints: - Primary key, RoomNo must be greater than Bed_No, Addr should not be null.
Consider the above tables and execute the following queries:
1. Display the details of patients who are from “Pimple Gurav”.
2. Delete the details of patient whose Bed_No is 1 and RoomNo is 105.
Q4. Consider the above tables and execute the following queries: [25 Marks]
1. Display the count of patient room wise.
2. Display the names of patients who are admitted in room no 101.
3. Display the disease of patient whose bed_No is 1.
4. Display the room_no and bed_no of patient whose name is “Mr Roy”.
5. Give the details of Patient who is admitted on 2nd flr in roomno 102.

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