Practical Slip 28 - 2019 Pattern

 C Language:

Q1) Write a program to accept a string and then count the occurrences of a specific

character of a string.

Q2) Write a program to accept two numbers as range and display multiplication table of all numbers within that range.

DBMS:

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

Blood (blood_id, blood_group, cholesterol_level, storage)

Donar (donar_id, name, address, gender, phone_no)

Relation between Blood and Donar is Many to one.

Constraint: Primary Key , Blood_group should not be null.

Consider the above tables and execute the following queries:

1. List out Donar wise Blood_group.

2. Display cholesterol_level of blood which is given by ‘Mr. Mahandule’.

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

1. Display the stock of blood whose group is “O+ve”.

2. Delete gender column from Donar table.

3. Update storage of blood to 100 bottles whose blood_group is “B+ve”.

4. Display blood group having maximum storage.

5. Display the details of donar in ascending order of donar_name.