Practical Slip 29 - 2019 Pattern

 C Language:

Q1) Write a C program to calculate factorial of a number using user defined function.

Q2) Write a program, which accepts a number n and displays each digit separated by tabs. Example: 6702 Output = 6 7 0 2

DBMS:

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

Country (CId, CName , no_of_states, area, location, population)

Citizen( Id, Name, mother_toung, state_name)

Relation between Country and Citizen is one to many.

Constraint: Primary key, area should not be null.

Consider the above tables and execute the following queries:

1. List out country wise number of states.

2. Display the name of country having minimum population.

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

1. Display citizens whose mother_tounge is ‘marathi’.

2. Update the population of India to 10000000.

3. Display citizen details in descending order by state_name.

4. Display country details having population more than 1000000.

5. Display Country details where ‘Ms Reshma’ is staying.