Practical Slip 3 - 2019 Pattern

 C Language:

Q1) Write a C program to accept temperatures in Fahrenheit (F) and display it in Celsius(C) and Kelvin (K) (Hint: C=5.0/9(F-32), K = C + 273.15)

Q2) Write a menu driven program to perform the following operations on strings using standard library functions:

1. Length of String 2. Copy String 3. Connect Two Strings 4. Compare two strings

DBMS:

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

Hospital (hno ,hname , city, Est_year, addr)

Doctor (dno , dname , addr, Speciality)

The relationship between Hospital and Doctor is one - to – Many

Constraints: - Primary Key, Est_year should be greater than 1990.

Consider the above tables and execute the following queries:

1. Delete addr column from Hospital table.

2. Display doctor name, Hospital name and specialty of doctors from “Pune City” .

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”.