Practical Slip 1 - 2019 Pattern

 C Language:

Q1) Write a C program to accept dimensions of a cylinder and display the surface area and volume of cylinder.  

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

a) Search employee by id

b) Display all employees

DBMS:

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

Emp(eno ,ename ,designation ,salary, Date_Of_Joining)

Dept(dno,dname ,loc)

The relationship between Dept & Emp is one-to-many.

Constraints: - Primary Key, ename should not be NULL, salary must be

greater than 0.

Consider the above tables and Execute the following queries:

1. Add column phone_No into Emp table with data type int.

2. Delete the details of Employee whose designation is ‘Manager’.

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

1. Display the count of employees department wise.

2. Display the name of employee who is ‘Manager’ of “Account Department”.

3. Display the name of department whose location is “Pune” and “Mr. Advait” is

working in it.

4. Display the names of employees whose salary is greater than 50000 and department is “Quality”.

5. Update Date of joining of employee to ‘15/06/2019’ whose department is ‘computer science’ and name is “Mr. Roy’.