Practical Slip 4 - 2019 Pattern

 C Language:

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) )

Q2) Create a structure Student (id, name, marks). Accept details of n students and write a menu driven program to perform the following operations. 

a) Search student by id

b) Display all students

DBMS:

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

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: 

1. Display the names of the hospitals which are located at “Pimpri” city.

2. Display the names of doctors who are working in “Birla” Hospital and city

name is “Chinchwad”.

3. Display the specialty of the doctors who are working in “Ruby” hospital.

4. Give the count of doctor’s hospital wise which are located at “Pimple Gurav”.

5. Update an address of Doctor to “Pimpri” whose hospital is “Ruby clinic”.