Practical Slip 27 - 2019 Pattern

 C Language:

Q1) Write a program to count the occurrences of vowel from a input string.

Q2) Create a structure Item (Ino, Iname, Price). Accept details of n Items and write a menu driven program to perform the following operations options.

1. Display all Items having price > 800

2. Display Item record with Ino=2

DBMS:

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

Student (rollno, sname, class, timetable)

Lab (LabNo, LabName, capacity, equipment)

Relation between Student and Lab is Many to One.

Constraint: Primary Key, capacity should not be null.

Consider the above tables and execute the following queries:

1. Add column Phone_No with data type int in Student table.

2. Display lab wise capacity.

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

1. Display practical time table of class ‘FYBBA(CA)’.

2. Display the LabName in which ‘Mr Advait’ is doing practical.

3. List out class wise students.

4. Delete the column equipment from Lab table.

5. Update capacity of Lab to 100 whose Number is 1.