Practical Slip 6 - 2019 Pattern

 C Language:

Q1) Write a C Program to accept a character from the keyboard and display its previous and next character in order. Ex. If character entered is ‘d’, display “The previous character is c”, “The next character is e”.

Q2) Write a program to accept a string and then count the occurrences of a specific character of a string.

DBMS:

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

Project (pno, pname, start_date, budget, status)

Department (dno, dname, HOD, loc)

The relationship between Project and Department is Many to One.

Constraint: Primary key.

Project Status Constraints: C – Completed,

P - Progressive,

I - Incomplete

Consider the above tables and execute the following queries:

1. Drop loc column from department table.

2. Display the details of project whose start_date is before one month and status is

“Progressive”

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

1. Display the names of project and department who are worked on projects whose

status is ‘Completed’.

2. Display total budget of each department.

3. Display incomplete project of each department.

4. Display all project working under 'Mr.Desai'.

5. Display department wise HOD.