Practical Slip 12 - 2019 Pattern

 C Language:

Q1) Write a C program to calculate sum of digits of a given input number.

Q2) Accept two numbers from user and write a menu driven program to perform

the following operations.

1. swap the values of two variables

2. calculate arithmetic mean and harmonic mean of two numbers

DBMS:

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

Movies (M_name, release_year, budget)

Actor (A_name, role, charges, A_address)

Producer (producer_id, name, P_address)

Relationship:- Each actor has acted in one or more movie. Each producer has produced many movies but each movie can be produced by more than one producers. Each movie has one or more actors acting in it, in different roles.

Constraint: Primary key, release_year > 2000, A_address and IP_address should not be same.

Consider the above tables and execute the following queries:

1. List the names of movies with the highest budget.

2. Display the details of producer who have produced more than one movie in a year.

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

1. List the names of movies with the second highest budget

2. List the names of actors who have acted in the maximum number of

movies.

3. List the names of movies, produced by more than one producer.

4. List the names of actors who are given with the maximum charges for their movie.

5. List the names of actors who have acted in at least one movie, in

which ‘Akshay’ has acted.